Загрузка страницы

15+ Excel Keyboard Shortcuts - Excel Tutorial

Excel tutorial on 15+ Excel keyboard shortcuts to help you be more efficient when working in Excel. One of the best ways to be efficient in Excel is by using keyboard shortcuts. Each second you save not reaching for your mouse can add up over a workday.

In this tutorial we'll go over these 15 top Excel keyboard shortcuts:

1. Ctrl+; to insert the current date
2. Add the current time by pressing Ctrl+Shift+:
3. Do both, by adding a space - press Ctrl+; SPACE Ctrl+Shift+:
4. Ctrl+D to copy the contents of the cell directly above – will copy the formulas if it contains formulas
5. Ctrl+R to copy what’s in the cell to the left
6. Press Ctrl+F to open the Find tool
7. Ctrl+H to open it in the Find & Replace tab
8. Ctrl+Shift+L to add Filters
9. Turn your number(s) into a percent by pressing Ctrl+Shift+%
10. Ctrl+Shift+! to apply number formatting with 2 decimals
11. Use Ctrl+Shift+~ to return to General style formatting
12. Create outside border by selecting your data and pressing Ctrl+Shift+&
13. Press Shift+F2 to insert a Comment
14. Press F7 to launch Spell Check
15. Insert a Table or Convert your data to a Table by pressing Ctrl+T
16. Press F11 to insert a Chart

Click here if you would like to read our step by step article on this: https://yacostasolutions.com/excel-keyboard-shortcuts-2/

And make sure to get your FREE pdf list of Top Excel Keyboard Shortcuts: https://yacostasolutions.com/newsletter/

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

Видео 15+ Excel Keyboard Shortcuts - Excel Tutorial канала Y. Acosta Excel Tutorials
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
21 августа 2019 г. 16:45:01
00:01:59
Яндекс.Метрика