+ Reply to Thread
Results 1 to 2 of 2

Need to autofill showing Excel cell number location...

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    San Diego, CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Need to autofill showing Excel cell number location...

    By that I mean I need to fill in a vast amount of cells with the actual cell number. So for example if I look at cell C1 it would have the text C1 in that cell. I will using this as sort of a template. Is there a way I can autofill all the rows and columns needed for this? Right now I am just manually dragging to autofill and I have hundreds of rows and columns to fill.

    Thx for any help!

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Need to autofill showing Excel cell number location...

    In C1, paste this:

    Please Login or Register  to view this content.
    And copy/paste into whichever cells you need
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Showing a cell value of a cell in a cell in another location.
    By Anuru in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2015, 11:16 PM
  2. [SOLVED] Using InputBox to locate a row and cell number, then to insert a value with the location
    By Surfboard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 07:45 AM
  3. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  4. Random Number Generation for Cell Location
    By pfunkallstar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2009, 12:53 PM
  5. using a number to select cell location
    By Trevor in forum Excel General
    Replies: 2
    Last Post: 07-03-2006, 12:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1