| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Office 2007 "go to special" shortcut function
your welcome, thank you for the feedback
"Michele" wrote: Perfect. That is what I was forgetting. Thank you soooo much. "Eduardo" wrote: Hi Michele, sorry I forgot something, once you selected the blank cells and click OK, tipe an = signal and then hit the arrow "Michele" wrote: That is what I have been trying, but as soon as I hit the arrow key, my cell selections go away as if I am aborting the action. So, when I press CTRL enter nothing happens. "Eduardo" wrote: Hi, Position in the first blank cell, hit CTRL G, special, Blank cells, then press the up arrow on the keyboard, Hold the CTRL key and press Enter "Michele" wrote: Recently we have upgraded to Office 2007. I have data that I import into Excel from another program. This program imports with some blank cells in which I would always do a ctrl+shift+8 (to select the data area) and then go to edit - go to- special - blanks and hit ok. This would then highlight all my blank cells. I would then hit the down arrow and enter and it would fill all of my blank cells with the data below. The problem I am having in Office 2007 is that after I use the go to special and select blanks, it selects all of my blank cells, but as soon as I hit the down arrow, the selection goes away. Can anyone assist ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keyboard shortcut for "paste special....."? | Excel Worksheet Functions | |||
| how to change "move selection after enter" in office 2007 | Excel Discussion (Misc queries) | |||
| How to change text color in a cell "comment" in Office 2007? | Excel Worksheet Functions | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| where can I find the "Calculated Field" in Office 2007 version? | Excel Worksheet Functions | |||
Hybrid Mode
