CTRL + Shift + &: Applies border to cells This shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells. Ctrl + Shift + U: Expand or collapse the formula bar Source: Isriya Paeireepairit/Flickr It will apply to multiple cells as well, if you have them selected. If you quickly want to change a cell to the currency format, you can select it and hit this shortcut. CTRL + Shift + $: Applies the currency format to the selected cells Then press these keystrokes and the insert hyperlink box appears, making the process that much easier. CTRL + K: Insert a hyperlinkįirst, you need to select where you want a hyperlink to appear. This shortcut quickly gives you access to the default date format. CTRL + Shift + #: Change date format with the day, month, and year
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |