Excel Features & Keyboard Shortcuts Everyone Should Know

To help you use Excel more effectively, here is a list of important functions, Excel Features & Keyboard Shortcuts and tricks Everyone Should Know. These Excel Formulas, Keyboard Shortcuts & Tricks will Save Your Time greatly.

Excel Features & Keyboard Shortcuts Everyone Should Know

1) Quickly select rows, columns, or the whole spreadsheet.

To select the entire spreadsheet in just one click, simply click the tab in the top-left corner of your sheet. Everything will be highlighted at once.

To select everything in a particular column of row use the below shortcuts:

Mac

  • Select Column = Command + Shift + Down/Up 
  • Select Row = Command + Shift + Right/Left 

PC

  • Select Column = Control + Shift + Down/Up 
  • Select Row = Control + Shift + Right/Left 

2) Format numbers into currency.

Have raw data that you want to turn into currency? Whether it be salary numbers, marketing budget, or ticket sales for an event, the solution is simple.

Just highlight the cells you wish to reformat and select Control + Shift + $.

The numbers will automatically translate into dollar amounts — complete with dollar signs, commas, and decimal points.

3) Quickly open, close, or create a workbook.

To open, close, or create a workbook, the following keyboard shortcuts will help you.

Mac:

  • Open = Command + O
  • Close = Command + W
  • Create New = Command + N

PC:

  • Open = Control + O
  • Close = Control + F4
  • Create New = Control + N

4) Customize the color of your tabs.

To color tabs, simply right click a tab and select “Tab Color.” A popup will appear that allows you to select a color from an existing theme.

 Excel Features & Keyboard Shortcuts

5) Automatically fill columns or rows with data.

Excel’s Auto Fill feature can minimize your work load. To do so, click and hold the lower right corner of a cell, and then drag it down or across into adjacent cells. As you release, the adjacent cells will be filled with the data from the cell you first selected.

Excel Features & Keyboard Shortcuts, excel keyboard shortcut for easy work, excel practice tutorial in bangla

Excel Features & Keyboard Shortcuts Everyone Should Know

6) Insert current date and time into a cell.

To add a date and time stamp to worksheet, selecting the cell into which you want to insert the time, date, or time and date.

Then, do one of the following:

  • Insert current date and time = Control + ; (semi-colon), SPACE, and then Control + Shift + ; (semi-colon).
  • Insert current date = Control + ; (semi-colon)
  • Insert current time = Control + Shift + ; (semi-colon)

7) Add a comment to a cell.

To make a note or add a comment to a specific cell, simply right-click the cell you want to comment on and then click Insert Comment. Type your comment in the text box. Click outside the comment box to save it.

Excel Features & Keyboard Shortcuts, excel, Excel Features & Keyboard Shortcuts everyone should know

8) Copy and duplicate formatting.

Formatting a sheet is tedious. If you have once done the formatting, you needn’t repeat the process next time. Using Excel‘s Format Painter, you can easily copy the formatting from one area of a worksheet to another.

To do so, select the thing you’d like to copy, then select the Format Painter option (paintbrush icon) from the dashboard.

Save

Save

Save

Make a Comment, Get Quick Help

comments are there to help you