LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Help with a quick formula?

Hi,
i am trying to write an excel sheet that will contain IP addresses. I
want the sheet to format so that I don't have to type in the address
in every box.

Example.

10.10.10.1
10.10.10.2
10.10.10.3
10.10.10.4

I have seen this before where someone put together a formula that they
either pasted in a ton of cells to fill the range in up to
10.10.10.254 or they just clicked on the next cell and the formula fit
in.

Can anyone help?

 
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
Quick Go To for Formula Components Other than First excel wonk Excel Worksheet Functions 1 June 2nd 07 06:57 AM
Quick formula Scooter Excel Discussion (Misc queries) 4 May 29th 07 04:40 PM
quick key to go to formula bar steveb New Users to Excel 6 July 25th 06 04:11 AM
I need help quick! Formula Cherry Excel Worksheet Functions 7 September 2nd 05 10:03 PM
Quick formula question jjjam Excel Worksheet Functions 8 July 8th 05 04:47 AM


All times are GMT +1. The time now is 12:47 AM.

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

About Us

"It's about Microsoft Excel"