How to Create and Format-Table in the Microsoft Excel?

In the previous post, we saw ‘How to Calculate the Difference between Two Dates?’, now we will learn about How to Create and Format-Table in the Microsoft Excel?.

Table of Contents hide

1 Where to find The Table option?

2 Shortcut Key to Format as Table

3 Share this:

4 Related

Where to find The Table option?

To find the Table option in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Insert Tab’ and under ‘Tables’ click on the ‘Table’ option.

From the Home tab under the ‘Styles’ group you will find the option ‘Format as Tables’

Select a cell within your data. Select Home > Format as Table. Choose a style for your table. In the Format as Table dialog box, set your cell range. Mark if your table has headers. Select OK.

Shortcut Key to Format as Table

First, select the table then press ‘ALT + N + T’ and hit the enter button or press ok [Tick the option My table has headers].

OR you can use 'ALT + H + T' select the table format via up and down arrow and hit the enter button.

With the help of this option, you can sort data in the table, filter data, etc., and many more features we will see in the next post.

June 1, 2021How To Create Multiple Ledgers in Tally Prime?

In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …

May 29, 2021TallyPrime: Important Shortcut Key ALT + G or GO To

In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …

Also read other articles @ EduTaxTuber

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

To export any ledger from tally select that ledger and set the date from start to end you want it then select the format to excel and configure it as per your need then export it.

Press “CTRL + E” and click on the configure button select the option that you want to enable it and hit the enter button. Select the file format……….Export Ledgers from Tally to Excel.

How to Print GST Invoice in TallyPrime?

To print the invoice launch TallyPrime and select the company for which you want to print invoice.

From the gateway of TallyPrime go to > Day Book press “F4” and select the “Purchase” under voucher types click on that the purchase entry will open.

Press “ALT +P” and click on the “CuRrent” and select the option “Preview” and click on the “Zoom” option. Press “Esc” to out from the preview window.