Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-15-2014, 07:01 PM
officeboy09 officeboy09 is offline How to modify the figures and cell format in multiple cells at once? Windows XP How to modify the figures and cell format in multiple cells at once? Office 2003
Advanced Beginner
How to modify the figures and cell format in multiple cells at once?
 
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
1) Enter 1 in an empty cell somewhere and copy it.
Select the range or the cells you want increased.
Right Click - Paste Special -Check "add" - OK

2) In C1 enter =A1&B1 then drag down as needed or double click the cross-hair at the right lower corner of the selected cell
Thx!

1) is very useful when the number of cells to modify is not too large for click & drag (sometimes I need to handle up to a thousand cells in a single column).

2) Not sure what C1 is. The only better way I currently use is to combine the cells in the 1st row, and then click & drag the cross-hair down for all succeeding rows. But like again, that wouldn't be a good way for handling a very large number of rows.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to modify the figures and cell format in multiple cells at once? How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
How to modify the figures and cell format in multiple cells at once? Copy table cell formatting across multiple cells / tables pakistanray Word Tables 2 10-31-2011 08:07 AM
How to modify the citation format MREGLIER Word 0 02-19-2011 03:31 AM
How to modify the figures and cell format in multiple cells at once? Auto-Format Tables of Contents/Figures judicial85 Word 3 12-25-2010 02:02 AM
How to modify the figures and cell format in multiple cells at once? Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft