Most useful keyboard shortcuts in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

Most useful keyboard shortcuts in Excel

Post by Admin »

In this tutorial you will get to know most useful keybord shortcuts in Excel.

So here we go :-)


Open a spreadsheet - Ctrl+O

Close a spreadsheet - Ctrl+W

Save a spreadsheet - Ctrl+S

Open the Save As dialog box - F12



Select the entire worksheet - Ctrl+A

Select an entire column in a worksheet - Ctrl+Spacebar

Select an entire row in a worksheet - Shift+Spacebar



Start a new line in the same cell - Alt+Enter

Image



Copy - Ctrl+C

Paste - Ctrl+V

Cut - Ctrl+X

Undo - Ctrl+Z

Bold - Ctrl+B



Insert a function - Shift+F3

Make an embedded chart from your selected data range - Alt+F1

Make a chart (in a separete chart sheet) from a range of selected data - F11



Go to Insert tab - Alt+N

Go to Data tab - Alt+A

Go to Page Layout tab - Alt+P

Go to View tab - Alt+W

Go to Formula tab - Alt+M

Go to the Home tab - Alt+H



Open the Format Cells dialog box - Ctrl+1

Open the Go To dialog box - F5



Open the Create Table dialog box - Ctrl+L or Ctrl+T


Open the current workbook in a separate window - Ctrl+F5



Move to the last cell on a worksheet - Ctrl+End

Select cells (from anywhere) to the last used cell in your worksheet - Ctrl+Shift+End



Add or edit a cell comment - Shift+F2

Image



Enter the current date - Ctrl+Shift+semi-colon ( ; )

Enter the current time - Ctrl+Shift+colon ( : )



Add or remove strikethrough formatting - Ctrl+5

Image



Add an outline border to a cell - Ctrl+Shift+ampersand (&)

Remove the outline border from any cell - Ctrl+Shift+underline (_)


Create or edit a hyperlink - Ctrl+K

For spelling check in selected cells or in worksheet - F7


Expand or collapse the formula bar - Ctrl+Shift+U



For more, consult Microsoft page here
BenStang
Posts: 1
Joined: Sat Apr 24, 2021 9:33 am

Re: Most useful keyboard shortcuts in Excel

Post by BenStang »

Amazing, a particularly incredible blog sharing the natural and data with us in every one of the areas. I'm a major fanatic of this blog for imparting commendable and remarkable substance to us as I can get help with research paper in order to finish my writing tasks. Continually anticipating getting such sort of data from them.
Beauvais
Posts: 4
Joined: Tue Sep 01, 2020 8:50 am

I am very enjoyed for this blog

Post by Beauvais »

I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy For More Information.
Reatha Adaway
Posts: 16
Joined: Tue Oct 08, 2019 9:46 am

Re: Most useful keyboard shortcuts in Excel

Post by Reatha Adaway »

Keyboard shortcuts are an absolute game-changer in Excel! They not only boost efficiency but also make spreadsheet tasks a breeze. Whether it's "Ctrl + S" for saving your work instantly or "Ctrl + C/V" for copying and pasting, these shortcuts are like magic wands. And, can you play minecraft on a mac while having Excel open thanks to these time-saving commands. They simplify navigation, formatting, and data manipulation, letting you zip through your tasks effortlessly. So, if you haven't already, dive into Excel's shortcut world, and you'll wonder how you ever managed without them. Happy Excel-ing!
Post Reply