shortcuts

I'm a heavy Excel user and love keyboard shortcuts. I'm working on a small project to run keyboard shortcuts on your computer from a tablet. I'm looking for feedback from other Excel users on how to make it most useful. I have a short Google survey (http://bit.ly/directflight) that I would...

I have a table that looks like this <tbody> Apr-13 455 45 23 4 May-13 5 5 5 5 35 </tbody> I need to fill out the blank cells with the respective year. If I select the entire area and hit ctrl-D, all the cells get the contents of the first one. I however want april and...

Hello. I have a userform I use to enter data onto a worksheet. I need to add a symbol (the 'degree' sign in my case) on occasion in some of the textbox fields. The userform takes focus, so I can't use the Insert menu to place the symbol. I've tried using the keyboard shortcut to enter the...

I am changing the name of an EXCEL 2007 workbook ('A.xls' to 'AB.xls') and then changing its location to another folder. I then am creating another workbook with the original name ('A.xls) and placing it in the original folder. Very simple and routine. I have a desktop shortcut pointed to the...

I frequently use Excel to make priority lists, or checklists: <tbody> Priority Item Description 1 Make a list 3 Check it twice 2 Don't pout </tbody> Is there a simple way to reorder the list? Of course I can type in new numbers and hit data->sort, but that often involves renumbering...

Hey is there a place where I can find the equivalent shortcuts in excel english-Spanish? I rather change my language to English but it seems I have to buy the english office pack -.-

I was wondering if there is a shortcut to run "Convert text to Columns" Using ALT+A+E+W+N gets you to the data preview that has a ruler, the part I need the shortcut for would be to get the ruler to the 10 mark without using the mouse? Any help would be appreciated. Thanks

I've customized the ribbon in my workbook in Excel 2007. Is it possible to make custom keyboard shortcuts to the procedures? My procedures look like Public Sub ProcedureName(control As IRibbonControl) End Sub

Hi All, I seem to remember a way to jump to a linked (not hyperlinked cell) but am having trouble. Hope you can help. Here's the application. 12 months of sales data in worksheets - Jan11-Dec11 and a Summary worksheet that is linked to cells (MonthlySales) in each sheet - ie =Jan11!c5...

I've assigned shortcuts keys to several macros in my personal workbook and in workbook specific macros, and suddenly none of them are working. Has anyone had this problem before?? I checked the security settings, they all look good. My computer just did an auto-update and I'm wondering if...

I am not able to use two distinct macro shortcuts in the same sheet. I have reviewed the macros and they appear to be set up correctly, but only the 2nd of the two will run via its shortcut. Both will run form the Macros menu option. Can someone point me to a resource to troubleshoot why the...

I like to define keyboard shortcuts for several symbols I often use. My computer is currently running both Excel 2003 and 2007. I was able to save my list of shortcuts in the 2007 version, such that each time I open a new workbook all the shortcuts were in place, but I can't seem to save...

An add-in has been installed within my Excel software and now I'm not able to use all of my keyboard shortcut keys. For example, Shift+Control+arrow down does not work any more. How do I adjust the settings to enable this again?

:)Hi all. Anyone know the short cut key to remove cell colour for Excel 2007??? Thank you :)

Hi all, I'm after a work around to select all ranges in a formula. ie When you click into the formula bar & all the ranges are surrounded by boxes & you can move, resize etc. When there are several boxes around the same range is it possible to move/resize all the boxes for that range instead...

Dear Anyone, I'm sure this question has been asked a million times, but I can't find it under keywords "Mac Shortcuts" here and astonishingly can't find anything under a Google search. Would anyone happen to have a list of the Excel keyboard shortcuts for a mac? There are a host of "hotkey"...

I thought maybe we could start a thread where everybody shares their favorite tips, tricks, and keyboard shortcuts for excel. My favorite is the F2 keyboard shortcut for bringing the cursor into a cell instead of clicking on it. What is yours?

Hi guys, I've been working on games lately and excel is a great tool for that except I couldn't figure how to properly use the arrow keys for the controls. My results of using GetAsyncKeyState have been mediocre. The OnKey is what I need since I've seen a Tetris on the internet which...