Shortcuts that make Excel® 2010 easy
When you see the boring gridlines on a spreadsheet, you would want someone to do the work for you, wouldn’t you? Excel isn’t that boring when you know about its shortcuts and little secrets. Let us see some of the key shortcuts that make your Excel experience simple and easy.
Find – In your Explorer, the shortcut key to finding data is “Ctrl+F” and this shortcut will help you search data in the worksheet, multiple worksheets, and this results in saved time.
Copy – Shortcut to the simple copy is ‘Ctrl+C’ and the little complicated copying would require you to select the cell, and drag it if you are copying the same value in the cells below it. You could also go with the ‘Ctrl+D’ shortcut which will copy-paste the value in the first cell of the whole selection.
Print – Printing your graphs or charts after you have worked on them is as simple as selecting the area in the worksheet that you want to have printed using the shortcut ‘Ctrl+P’
Go to – The shortcut for the ‘go to’ option is ‘Ctrl+G’ which will help you to go to the cell that you want. There’s a special key on the window that appears when you press ‘Ctrl+G’ which will give you the special options to apply to your query.
Table – When you have your data ready and you want to create a table for it, ‘Ctrl+T’ is the shortcut for you. This shortcut will create a table for you with the column and row headings depending on the first row and column for the data that is selected.