All Questions
Tagged with microsoft-excel-2016 keyboard-shortcuts
11
questions
0
votes
2
answers
30
views
How to Move the cursor one word to the left in ms excel?
In MS Word, Ctrl+left arrow helps use move to the previous word quickly. But the same shortcut in MS Excel takes us to the previous cell. I can't find any shortcuts for the same in the Microsoft's ...
0
votes
3
answers
11k
views
Pivot Table: Expand/collapse all rows using keyboard shortcut
In an Excel 2016 pivot table:
Is there a keyboard shortcut we can use to expand or collapse all rows at a given level? For example, CTRL + click the plus sign to expand all rows?
I'm aware that it's ...
- 157
1
vote
1
answer
2k
views
Is there a keyboard shortcut to put the focus on the name box in Excel 2016?
I wonder if I can jump to the name box (the one above the column "A", and below the ribbons) via a keyboard shortcut.
(somewhere I've read about Alt+F3, but it doesn't work)
Thanks in ...
- 111
4
votes
1
answer
160
views
Force Excel to re-parse a whole column of dates
I have a series of dates in a column, currently recognized as text. Thus sorting doesn't work correctly.
When highlighting the column and changing the format to Date, Excel still recognizes it as ...
- 1,900
0
votes
1
answer
57
views
Is there an equivalent of the CTRL+. shortcut key in Excel 2016 and Excel 365?
It seems that this shortcut key was removed and I haven't been able to find a ribbon based replacement for it.
CTRL . is the Move active cell clockwise in selection which is quite key for efficient ...
- 432
0
votes
1
answer
78
views
How do I use keyboard shortcuts to enter a value into a cell that has a list data validation entry?
So I used data validation to only allow an user to enter values from a list. How do I select something from the list without using the mouse?
For example, here's what I made:
Clicking on the little ...
- 1,402
9
votes
7
answers
54k
views
MS Excel: How to use format painter with just the keyboard?
If you want to paste a format, you can copy and use the keyboard shortcut to paste special (Ctrl + Alt + V). MS Excel also has a useful format painter tool. You can select it using a keyboard shortcut ...
- 1,402
2
votes
2
answers
49k
views
Does an excel keyboard shortcut to highlight a cell yellow exist?
Is there an keyboard shortcut to highlight a cell yellow (or maybe just the most recent color used)?
What I am not looking for (I want something that is preset in excel and more efficient):
Alt-H-H +...
- 175
5
votes
0
answers
13k
views
Change keyboard shortcuts in Microsoft Excel 2016 in Windows [duplicate]
In Excel 2016, I would like to change the keyboard shortcut for the Search command from CTRL+B to CTRL+F so that this command has the same keyboard shortcut as in other programs. However, I could not ...
- 2,569
4
votes
3
answers
6k
views
fix for unhiding column in Excel has stopped working
I have just moved to Windows 10 and Excel 2016 (from Excel 2000) and found that CTRL-SHIFT-0 no longer works to unhide columns, because it's been hijacked by a language setting (for hotkeys for ...
- 41
8
votes
2
answers
13k
views
How to create custom shortcuts in Excel 2016 for mac
I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. being able to create new shortcuts for ...
- 183