| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go To Visible Cells - In Excel 2007
Friends - In previous versions of Excel, you used to be able to go to
Edit-Go To - Visible Cells Only, and copy and paste only cells that were visible (because of a filter or because you are hiding cells). Does anyone know if Excel 2007 has this feature? I "Searched" it on the Ribbon and got nothing. Could it be that they got rid of this? I wouldn't be surprised Excel 2007 is really underwhelming. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Go To Visible Cells - In Excel 2007
Hi Taversas,
With Excel 2007: Select Home Tab | Editing Group (Extreme right) | Click Binocular Icon --- Regards. Norman "Taveras" wrote in message ... Friends - In previous versions of Excel, you used to be able to go to Edit-Go To - Visible Cells Only, and copy and paste only cells that were visible (because of a filter or because you are hiding cells). Does anyone know if Excel 2007 has this feature? I "Searched" it on the Ribbon and got nothing. Could it be that they got rid of this? I wouldn't be surprised Excel 2007 is really underwhelming. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Go To Visible Cells - In Excel 2007
Hi Taveras,
Just to add, clicking the Binocular icon opens the Find and Select menu. Excel 2007 still suports the F5 and Ctrl-G shortcuts to the GoTo dialog window. --- Regards. Norman "Norman Jones" wrote in message ... Hi Taversas, With Excel 2007: Select Home Tab | Editing Group (Extreme right) | Click Binocular Icon --- Regards. Norman |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Go To Visible Cells - In Excel 2007
Thanks very much!! :-)
"Norman Jones" wrote: Hi Taveras, Just to add, clicking the Binocular icon opens the Find and Select menu. Excel 2007 still suports the F5 and Ctrl-G shortcuts to the GoTo dialog window. --- Regards. Norman "Norman Jones" wrote in message ... Hi Taversas, With Excel 2007: Select Home Tab | Editing Group (Extreme right) | Click Binocular Icon --- Regards. Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - cell borders not visible when cells colored | Excel Discussion (Misc queries) | |||
| Excel 2007: picture not visible on screen, but prints | Excel Discussion (Misc queries) | |||
| Excel 2007 Workbook Not Visible | Excel Discussion (Misc queries) | |||
| How do i paste only into visible cells in Excel? | Excel Discussion (Misc queries) | |||
| charts are not visible in excel 2007 | Charts and Charting in Excel | |||
Linear Mode
