domingo, 22 de janeiro de 2017

Alguns truques do Excel que talvez você não conheça

Achei esse link bem interessante.

https://blogs.office.com/2015/04/08/5-easy-and-powerful-excel-features-you-may-not-know-about/

Alguns truques de teclas

Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row
Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell
Shift-F11 = Creates a new blank worksheet within your workbook
F2 = opens the cell for editing in the formula bar
Control-Home = Navigates to cell A1
Control-End = Navigates to the last cell that contains data
Alt-= = Autosums the cells above the current cell

Nenhum comentário: