LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sn0wman
 
Posts: n/a
Default Change all values in an excel column at once?

I have an Access database I'm attempting to modify a bit in Excel. It has
over 16500 rows. I want to add 30 to all 16500+ values in a certain column.
Is there any way to do this in one step, or am I doomed to manually change
them one at a time?
 
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
How do I summarize totals for a list of values in Excel? KelleyS Excel Worksheet Functions 2 April 13th 05 09:56 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
excel change default column sort to current selection john palmer Excel Worksheet Functions 2 March 8th 05 03:07 PM
Generating Correlated Random Values in Excel Randy Excel Discussion (Misc queries) 2 January 16th 05 09:50 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 11:10 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"