Did you Know about Excel Rows and Columns

Know about Microsoft Excel

Worksheet Size

there are 1,048,576 rows and 16,384 columns in one worksheet

 

 

Using VLOOKUP function (step by step tutorial)

Excel Tutorial

Using VLOOKUP() function (step by step tutorial)

How to use VLOOKUP() function in Excel

using VLOOKUP function

Calculate growth formula in Pivot Table

Excel Tutorial

Calculate growth formula in pivot table

How to calculate growth formula in PivotTable

Ctrl + G (display GoTo dialog box)

Excel Shortcut Keys

Ctrl + G

Displays the Go To dialog box.

F5 also displays this dialog box.

 

Excel Game : Sudoku in Excel - Work and Play

Sudoku in Excel—Microsoft OfficeDocs.com

Excel Shortcut Keys: Ctrl+F (Find data)

Excel Shortcut Keys

Ctrl + F

Display the Find and Replace dialog box, with the Find tab selected.

You can find the data or text using the Ctrl+F

 

Excel Shortcut Keys : Ctrl + Shift + ) - (unhide Columns)

Excel Shortcut Keys

Ctrl + Shift + )

Unhide Columns

Unhide any didden columns within the selection.

 

exce0

Create a Pivot Table

Excel Tutorial

Create a pivot Table

How to create a Pivot Table in Excel

Excel Keyboard Shortcut : Ctrl + E

Excel Shortcut Keys

Ctrl + E

Adds more value to the active column by using data surrounding that column.

 

Excel Shortcut Keys: Ctrl + D (Duplicate data)

Excel Shortcut Keys

Ctrl + D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.