Tuesday, September 24, 2013

Steps To Select Only Visible Cells In Microsoft Excel 2007

Microsoft Excel is a spreadsheet program available in the Microsoft Office suite of programs that helps in storing data in an arranged and orderly manner. It also contains tools for calculation, graphing and pivot tables for performing various activities in the program. When one tries to copy cells in a range, most of the times, cells that are hidden or filtered from the selection also get included in the selection automatically.
However, there is no need to worry if you need to select only the cells that contain text or objects, as there is a hidden tool in the Excel program that can let you select only the cells that are visible. It is possible to add a button of the hidden tool in the Quick Access Toolbar located beside the Office logo in the program window. You can also make selection of only the visible cells using a set of keyboard shortcuts keys. Below we describe steps from the Excel tech support team for selecting only the visible cells.

Using the Select Visible Cells Only option
  • Launch the Microsoft Excel program by double clicking on the shortcut icon present in the desktop or by clicking on the quick launch bar. Open the file that you would like to work on by clicking on the Open tab and then selecting the file in the window that opens.
  • To customize the Quick Access Toolbar, right click on the menu bar and then select the option that reads Customize Quick Access Toolbar.
  • Click on the option Commands Not in the Ribbon in the drop down menu generated by clicking on the Choose commands from menu option.
  • Click on the option Select Visible Cells from the list that appears and then click on the Add button and then on the OK button to add the tool to Quick Access Toolbar. Now you will be able to see the Select Visible Cells Only button in the Quick Access Toolbar.
  • Now select the range of cells that you want to select including the hidden rows and columns. After selecting, click on the Select Visible Cells Only button to select only the visible cells and to remove the hidden cells in the selection.
If you find any difficulties in making a selection of only the visible cells in the Microsoft excel program, contact the Excel tech support center for further troubleshooting tips.

No comments:

Post a Comment