1 / 4

Managerial Spreadsheet Modeling NBA 6430

Managerial Spreadsheet Modeling NBA 6430. "Select Visible" command. Aydin Tuncer (at649). 1. " Select Visible " command. Objective :

amos-dunn
Download Presentation

Managerial Spreadsheet Modeling NBA 6430

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Managerial Spreadsheet Modeling NBA 6430 "Select Visible" command Aydin Tuncer (at649) 1

  2. "Select Visible" command.. Objective : "Select Visible" Command is a handy tool to use in copy & paste operation when you have some hidden rows/columns and want to exclude them while copying the data. Where to find : The command can be added to the QAT or the Personalized Ribbon from Excel Option / Customized QAT or Customize Ribbon section. "Select Visible" is under "Commands Not in the Ribbon" option.

  3. "Select Visible" command.. Original Data : Data to be copied, with hidden columns: • If we use standard Copy & Paste : • Select the yellow area ( where columns 4-7 are hidden) • Select Copy command • Paste to the target location However, the targeted result is

  4. "Select Visible" command.. • To get the targeted result which does not contain the hidden columns : • Select the yellow area ( where columns 4-7 are hidden) • Select Select Visiblecommand • You will see the difference in the selected area, the hidden columns will be unselected (unshaded) • Select Copycommand • Paste to the target location • Then we will get only the yellow highlighted part of the data which we want to copy 1 4 2 3 First, select the Select Visible command, then select Copy & Paste Commands 5

More Related