Tagged Questions
1
vote
1answer
47 views
Excel copy downwards [duplicate]
In MS Excel, if you select two cells containing text like "x1", "x2" and drag the bottom-right corner of the selection, it continues the pattern "x3", "x4", "x5" etc.
Is there a way to do this using ...
0
votes
1answer
28 views
How to customize Paste Value Excel Short Cut
I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
0
votes
0answers
21 views
Is it possible to use alt-XYZ shortcuts on Excel on OS X?
I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.
1
vote
1answer
86 views
How can I set a keyboard shortcut to switch between Excel tabs?
I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important.
I need Excel to switch ...
1
vote
0answers
71 views
Keyboard Shortcut to Fit Column Width to Text in Mac Excel?
I know this on a PC. It is Alt+O,C,A, as explained in this question.
Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac?
I'm ...
2
votes
4answers
66 views
How to copy a forumla in excel using only the keyboard?
I run into this situation a lot. I have a column of data (A) and I created a formula in B1 that I wish to copy from B2 to B5. This is just a tiny example, because usually I'm dealing with thousands ...
0
votes
2answers
646 views
Create shortcut key to insert new row using Excel 2010
Tried to create a macro in Excel to insert a row:
Sub InsertRow()
'
' InsertRow Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
Selection.EntireRow.Insert
End Sub
However, this does not insert a ...
3
votes
3answers
384 views
Can I reactivate the cursor keys for modifying a cell reference in a formula?
When I enter an Excel formula by hand avoiding the mouse, I can conveniently reference cells by using the arrow keys (->,<- etc.). For example, I can enter the formula =A2&B2 in cell C2 by ...
1
vote
2answers
499 views
Ctrl + Shift + Arrow stopped working
When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...
3
votes
2answers
653 views
Move to end of selection in MS Excel (2003)
I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of ...
1
vote
1answer
116 views
Specific excel shortcuts
I am trying to create specific keyboard shortcuts with only one key in Excel 2007. For example:
when I press Enter I want to move one cell left and then one cell down
and when I press * to move ...
0
votes
3answers
736 views
Is there a shortcut in excel that will expand the column width to show the entire column header
Is there a shortcut in excel that will expand all the column width(s) to show the entire column header as well as complete column
data. Now I need to go to each and every column in the excel sheet and ...
0
votes
2answers
1k views
Switch to first/last worksheet directly with keyboard
Is there a keyboard shortcut to directly go to first/last worksheet in Microsoft Excel without cycling through all with Ctrl+PgUp/PgDn?
1
vote
2answers
374 views
Is there any way to set up a keyboard shortcut for specific symbol in MS Excel?
How to set up a keyboard shortcut for specific symbol in MS Excel? Let's say euro sign wanted on Ctrl+Alt+e.
10
votes
5answers
11k views
Shortcut in Word or Excel for Special Paste?
If I want to paste without any formatting, I have to go to the "Paste" button on the ribbon and click "Paste Special" and then "unformatted text".
Is there a shortcut like Ctrl+V that'll ...
0
votes
4answers
3k views
How to copy-paste absolute cell references temporarely as relative references in Excel?
In Excel (2007), when cells that contain absolute references (for example: $A$3) are copied, the absolute reference remains the same. This is by design, and the reason of using absolute references.
...
1
vote
2answers
2k views
Is there any shortcut to iterate through Excel's worksheet tabs?
Is there any keyboard shortcut to iterate through Excel's worksheet tabs more easily?
Maybe something that would allow me to see all the tabs together and select one of them to switch to it.
2
votes
2answers
7k views
How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard
I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key).
Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...
1
vote
0answers
122 views
Excel keyboard shortcuts are switched – how do I set them back to their defaults?
I have a spreadsheet created by someone else. They switched Ctrl+Home to go to the beginning of the row, and Home to the start of the worksheet.
Also, I have the Tab key jumping 30 columns to the ...
1
vote
3answers
637 views
Excel - Select entire column from the selected row
No need for VBA. I just need a keyboard shortcut.
I am trying to select the entire column minus the first 5 rows and do Format Cell.
I tried Ctrl + Shift + Down Array, but it takes me all the way to ...
6
votes
1answer
806 views
Microsoft Excel Mac, keyboard shortcut to edit in cell
In Microsoft Excel for Mac 2011 (14.0.0) how can I modify the enter/return key to edit in cell instead of moving the selection down? I know that in Preferences > Edit you can uncheck the box that says ...
2
votes
1answer
242 views
Is there a keyboard shortcut to circularly switch sheets in Excel?
In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the ...
2
votes
4answers
19k views
Keyboard shortcut to change case of text in cells in Excel 2010?
Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)?
All my searches lead me only to functions to do this. But that is not what I want.
4
votes
1answer
8k views
Fit column width to text shortcut?
I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?
3
votes
1answer
1k views
Shortcut to accept suggested formula in Excel
I'm working with a lot of formulas in Excel 2007 and I would like to know what shortcut key you need to press to accept the suggested formula.
When I type in =DEG the first suggested formula is ...
1
vote
3answers
67 views
Copying cell to other cells in MS Excel
I want to copy a cell's data to the 4 cells below it.
ex: If I have 'apple', I need
apple
apple
apple
apple
apple
Please suggest to me a short cut that will do this.
1
vote
1answer
683 views
Keyboard shortcut to insert into cell in MS Excel (2008) on a Mac?
Keyboard shortcut to insert into cell in MS Excel (2008) on a Mac?
In Windows, F2 will put the cursor at the end of a cell's text. What's the keyboard shortcut to do this on a Mac?
1
vote
1answer
3k views
How do I assign a new keyboard shortcut in Excel 2010
I need a keyboard shortcut for Merge & Center. I'd like it to be Ctrl+Shift+M. I am unfamiliar with Macros as was suggested in another answer and when I go to Options, I can't find shortcuts...I ...
16
votes
4answers
42k views
How do you customize Excel 2010 keyboard shortcuts?
How do you customize Excel 2010 keyboard shortcuts? This article from microsoft.com provides instructions for "Microsoft Office 2010" but seems only apply to Word, not Excel.
...
1
vote
1answer
2k views
Shortcut to calculate a specific range in Excel
In VBA this can be easily done using the range.calculate command.
Once somebody showed me how to do it in Excel with a keyboard shortcut but I do not remember it any more.
I have been searching the ...
9
votes
5answers
16k views
Excel: keyboard shortcut to move (swap) column left or right?
Is there a way to move a column (or row) to the left using only the keyboard?
I known I can use ctrl-space (shift-space) to select a column (row), but how to move it to the left or right, actually ...
0
votes
2answers
2k views
Keyboard shortcut in excel for expanding the pivot table row?
I'm able to expand/collapse the row in the pivot table with mouse by:
right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu.
or double ...
8
votes
2answers
3k views
Keyboard shortcut to switch between sheets in Excel
Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
1
vote
3answers
932 views
What's the easiest way to get current time into a field in Excel?
I'm recording results into an Excel spreadsheet, and I want to record the time I enter the results. In Notepad, one can simply press F6 to get the current time stamp. Is there a simple/easy way to ...
1
vote
4answers
6k views
What's the shortcut in excel to show/hide cell comments?
what's the shortcut in excel to show/hide cell comments?
0
votes
2answers
767 views
How to get Excel out of Select Cell mode
Looking for a tip on Microsoft Excel (2003):
If you click on a cell containing a formula, click into the formula, and click away, Excel will enter the cell or range you next select into the formula ...
1
vote
2answers
113 views
Excel Shortcut to Editbar
I currently have to do some work in an Excel sheet and as we all know Enter jumps to the next row (at the current column) and I can start typing.
Until I have to use the arrows (Ctrl + ...
11
votes
4answers
10k views
How can I change the focus in Excel to the formula bar via the keyboard?
I like to avoid using my mouse as much as possible, but on occasions when I need to type directly into the formula bar I am currently forced to 'rattle the rodent'. Does anyone know a way to move ...
