0
votes
2answers
17 views

Delete previous word in Excel

In almost any other application, Ctrl+Backspace deletes the previous word when editing text. In Excel 2013, it jumps the view to the active cell. Is there an alternate shortcut for "delete previous ...
0
votes
1answer
38 views

Ctrl+[ not working in Excel 2013

The keyboard shortcut Ctrl+[ (trace precedents) is not working on my new laptop. I am using Excel 2013. Can anyone explain how to set it to work?
1
vote
1answer
23 views

What's the shortcut to open the “Insert Function” dialog?

I'm typing a function in a cell in Excel and I want to choose the arguments by hand. What's the shortcut to bring up the dialog menu entitled "Function Arguments" that appears when I click the "fx" ...
0
votes
2answers
76 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
3answers
5k views

How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
1
vote
0answers
74 views

Most efficient way to paste cell reference into clipboard as string? [closed]

I wish to copy the reference to a Range in Excel as a String as efficiently as possible. I wish primarily to minimise keystrokes and conditionally not use custom VBA or the mouse. At the minute, I ...
1
vote
1answer
197 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 ...
1
vote
4answers
12k 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
1answer
2k views

Excel Workbook Desktop Shortcut with Auto password?

I've got a bunch of password-protected Excel workbooks on my secured LAN (no wan) computer. Is it possible to parse the password into a shortcut so it would automatically open a workbook as long as ...
5
votes
3answers
16k 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.
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.
3
votes
2answers
2k views

Excel shortcut: switching back and forth between that last active sheet and the current exit sheet

I know the shortcut CRTL + page up/down but I need the similar function that exists eg in internet explorer: Shift + alt I found a macro that is close but does not entirely solve the problem: If ...
2
votes
5answers
11k views

What's the shortcut in excel to show/hide cell comments?

what's the shortcut in excel to show/hide cell comments?