Our office is open from
Monday to Friday 09:00-17:00
52 Makrygianni Street,
17342 Agios Dimitrios,
Athens, Greece
Phone : (+30) 218 218 3196
Fax : (+30) 210 991 3327
info@computech.gr
Web : www.computech.gr
Copyright © 2024 Computech Business Solutions. All rights reserved.
Excel’s Ribbon is great for finding everything you might ever want to do in a spreadsheet, particularly things you don’t do frequently, like managing and querying data connections or automatically grabbing geographic statistics from the internet and inserting them into cells.
But if you’re looking to do things fast, you’ll find keyboard shortcuts far more useful. Why bother to lift your hands from the keyboard if you want to open or close a file, apply formatting to cells, navigate through workbooks, undo and redo actions, calculate all worksheets in all open workbooks, and more? With keyboard shortcuts you won’t have to.
There are keyboard shortcuts to accomplish a vast array of tasks in the Excel desktop client, in both the Windows and Mac versions.
combination
combination
comments
worksheet or selected range
Fn-down arrow /
Fn-up arrow
left / right
Option-Page Down or
Fn-Option-up arrow /
Fn-Option-down arrow
the left / right
Control-Page Up or
Option-right arrow
/ Option-Left arrow
worksheet
Control-Fn-Left arrow
has content in it
Control-Fn-right arrow
left while in a cell
right while in a cell
the Ribbon, the task pane, and
Zoom controls
is open, switch to the next one
Ctrl-Shift-Spacebar
one screen
Shift-PgUp or
Shift-Fn-down arrow /
Shift-Fn-up arrow
beginning of a row
Shift-Fn-left arrow
beginning of the worksheet
Control-Shift-Fn-left arrow
a selection
in a selection
to the clipboard
into a cell
dialog box
Control-Option-V
move to the next cell down / up
dialog box
the cursor to the end of the text
⌘-Fn-right arrow
text from the cursor to the end
⌘-Shift-Fn-right arrow
for selected cells that contain data
(Windows) / Modify Cell Style dialog
box (Mac)
selection
two decimal places
no decimal places
month, and year
12-hour clock
and cell values
from the cell above into the
current one
workbooks that are open
Search box
cursor is on a chart
is on a chart
cursor is on a table
cursor is on an image
Popular Post
5G Radiation Is Harmful
December 14, 202110 hidden Office 365 features to boost
September 30, 2021iPhone 13 vs. iPhone 12, 12 Pro
September 19, 2021Popular Categories
Instagram Feeds
Popular Tags
Archives
Recent Posts
Recent Comments
Archives
Categories
Meta
Popular Posts
5G Radiation Is Harmful
December 14, 202110 hidden Office 365 features to boost
September 30, 2021iPhone 13 vs. iPhone 12, 12 Pro
September 19, 2021Contact Us
Address: 52 Makrygianni str.
P.C. 17342, Ag. Dimitrios, Greece
Phone: +30 218 218 3196
Fax: +30 210 9913 327
Mobile: +30 6945 550 460
Mail: info@computech.gr
Web: https://www.computech.gr