We stray a little from Excel in the blog, mostly discussing automation of boring tasks and self improvement using technology. Shift+F4 Ctrl+Shift+F4: Repeats the previous search. Key Description Other useful shortcut keys F10 F11 F9 Now, select the entire range on which you want to apply the calculation. Paste a name from the Paste Name dialog box (if names have been defined in the workbook. (F5 also opens this dialog box.) Copy values without formatting Instead, from the menu, use Insert > Name > Paste. ![]() ![]() If you would like to change the format of a date or time entered in an Excel cell, you can use a keyboard shortcut to open the formatting dialog box.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |