#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Small Business..

I have a formatted excell sheet with 3 columbs of #s I want to increase all
by 10% without doing individual cell.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Small Business..

Choose a blank cell somewhere and enter 1.1 in that cell (equivalent
to 110%). Select the cell and <copy, then highlight the three columns
of numbers and Edit | Paste Special | Values (check) | Multiply
(check) | OK then <Esc.

You can delete the 1.1 from the first cell.

Hope this helps.

Pete

On Oct 24, 11:35 pm, Small business needs help.
m wrote:
I have a formatted excell sheet with 3 columbs of #s I want to increase all
by 10% without doing individual cell.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Small Business Financial Manager Louise Excel Discussion (Misc queries) 0 November 22nd 06 07:51 PM
HOW DO I SET UP A SMALL BUSINESS USING EXCEL? RAH Excel Discussion (Misc queries) 2 August 10th 06 12:49 AM
I have a small business would like to set up a contact base boatman12 Excel Discussion (Misc queries) 1 May 9th 06 11:16 PM
Small Business Financial Manager johnnywyoming Excel Discussion (Misc queries) 0 November 14th 05 11:10 PM
feasibility study for small business El Rasheed Excel Discussion (Misc queries) 1 March 19th 05 05:05 PM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"