Hónap: 2018 augusztus

7 easy-to-remember Excel shortcuts that can save you hours

Okay, Excel shortcuts are useful, but how do you remember so many letters? It’s best to stick to something. (You are lucky, because you understand English, and it’s easy to remember the words. But I mostly teach Hungarians, so I also have teach them some English as well.)

Here are 7 easy-to-remember Excel shortcuts:

You’ve probably seen poker players risking everything at Excel shortcut to select ALL is Ctrl Abet, saying “All in”. 

You can easily remember the shortcut to select everything (all cells) in an Excel table is Ctrl A (all). “7 easy-to-remember Excel shortcuts that can save you hours” bővebben

How can you add comments to an Excel table?

I’ve seen others add comments, insert notes into Excel spreadsheets – like post-it or sticky notes. How can I do the same? Can it be printed?

Answer: right-click on the cell and click Insert Comment.

Add comments to your file

You can add comments using the right mouse button or use Shift F2 shortcut. First, they look spectacular, take my advice, rather avoid using the comments. Instead, put the text into a separate cell – make a Comment column – and you can easily filter or sort these information.
 “How can you add comments to an Excel table?” bővebben