Business Plan Pro Tip: Shortcuts for Spreadsheets

Fill RightLike to work in spreadsheets, but want the speed and ease of automatically filling in related columns or rows? Business Plan Software has a shortcut for you:

Fill other columns

  1. Click to select the cell containing data you wish to replicate
  2. Hold down the Shift key, and highlight as many data-entry (blue) cells to the right of the original cell as you wish
  3. On the Edit menu, click Fill Right
  4. All the cells you selected will now contain the same data (number or formula)

Fill other rows

  1. Click to select the cell containing data you wish to replicate
  2. Hold down the Shift key, and highlight as many data-entry (blue) cells below the original cell as you wish
  3. On the Edit menu, click Fill Down
  4. All the cells you selected will now contain the same data (number or formula)

You can find more tips like this by searching on “Spreadsheets” in your built-in Help.

3 Comments on this post »

show or hide Comment by Gry przeglądarkowe on 2016-08-19 07:20:41

You are my inspiration, I possess few web logs and often run out from post :). “Follow your inclinations with due regard to the policeman round the corner.” by W. Somerset Maugham.

(Comments wont nest below this level)
 
show or hide Comment by DC on 2016-08-21 11:46:38

Dead pent content material, Really enjoyed examining.

(Comments wont nest below this level)
 
show or hide Comment by Przeglądarkowa gra on 2016-09-01 12:15:04

Some really good info , Glad I detected this. “Three things you can be judged by your voice, your face, and your disposition.” by Ignas Bernstein.

(Comments wont nest below this level)
 
Name (required)
E-mail (required - never shown publicly)
Your website
Your comment

Customer Service

1-800-229-7526

customerservice@paloalto.com