0
votes
1answer
58 views

Excel: Keyboard shortcuts to navigate Ribbon Menu Tabs

Is there a keyboard shortcut to navigate between (for example) the Home Tab and the Insert Tab in the ribbon menu in Excel (2010). Like ctrl+tab in a browser to switch tabs. Pretty sure I've seen ...
0
votes
0answers
67 views

What is the Windows equivalent of this Mac Excel shortcut?

I can't remember how I learned how to do this, but I'm 90% sure it's a built-in default shortcut for Mac Excel 2011. Make a selection in your spreadsheet. Hit option-tab to move that selection to the ...
0
votes
2answers
69 views

Shortcut to switch between different spreadsheet in excel? [duplicate]

Is there a keyboard-shortcut to switch between different sheet in MS-excel?
0
votes
1answer
148 views

How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]

If I press CRTL+Down I move to the cell before the empty cell. If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell. Now if I want to auto fill ...
0
votes
0answers
11 views

Change focus in Excel to formula bar via keyboard using Excel 2011 in Mac [duplicate]

I want to ask the same question as this one but for Microsoft Excel 2011 in Mac. The issue is that in Excel 2011 for Mac there is no Tools -> Options.
2
votes
1answer
2k views

Microsoft Word 2013 - Cannot Paste Special

In Word 2013, I am trying to paste the contents of my clipboard which contains a formatted table from Excel into a word document. When I press ALT+E and then press S to bring up the special paste ...
2
votes
2answers
2k views

Excel: how to delete text and fill color?

In Excel you can press the Delete key to delete the contents of highlighted cells, but not the cells' fill color. Instead you need to click on the Fill tool on the ribbon and choose No Color. Is ...
1
vote
1answer
122 views

Map Page Up, Page Down and Num Lock just for Excel with Autohotkey

I would like to map these keys to the corresponding text: Page Up ( Page Down ) Num Lock = I want to do this with Autohotkey but I'm having a hard time figuring out the script. I also only want ...
1
vote
3answers
594 views

Does excel have an arrow key shortcut to skip blank cells?

In most versions of Excel (I'm using 2010), pressing ctrl+up or ctrl+down will take you to the edge of the current data region or the start of the next data region in a worksheet. Effectively skipping ...
1
vote
1answer
77 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
2k 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
60 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.
2
votes
3answers
9k 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
557 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
111 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 ...
1
vote
2answers
1k 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 ...
5
votes
3answers
891 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 ...
2
votes
2answers
2k 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
3k 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
178 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
4answers
8k 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 ...
1
vote
3answers
4k 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
992 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.
16
votes
9answers
28k 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
6k 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. ...
5
votes
3answers
12k 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
3answers
14k 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
186 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
1k 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 ...
7
votes
2answers
2k 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
453 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
45k 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.
5
votes
1answer
15k 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?
4
votes
1answer
2k 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
70 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
793 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
3answers
6k 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 ControlShiftM. I am unfamiliar with Macros as was suggested in another answer and when I go to Options, I can't find ...
20
votes
4answers
74k 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
3k 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 ...
10
votes
6answers
24k 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
4k 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 ...
9
votes
2answers
4k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
1
vote
3answers
1k 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
9k 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
1k 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
146 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 + ...
15
votes
5answers
17k 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 ...