Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel stupid question

Posted on 2014-04-17
6
Medium Priority
?
886 Views
Last Modified: 2014-04-17
Hello All,
Sure enough I  am not sure what i am doing ...playing with a bunch of formulas :( done by someone esle...
What does this mean?
Sheet1!$1:$1048576
0
Comment
Question by:Rayne
6 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 40007562
Its referring to cell A:1048576 on a sheet called sheet1
0
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 200 total points
ID: 40007571
... you can force Excel to use numbers for both row and column rather than column letter
and row number

BTW the $ indicates the cell reference is fixed and will not be changed of the formula is copied or moved.
0
 

Author Comment

by:Rayne
ID: 40007612
Couldn’t get that? It is referring to 1048576 columns across starting from column A? or what it is the row starting from row 1 all the way to 1048576th row? Across or down….please explain
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 23

Accepted Solution

by:
NBVC earned 1600 total points
ID: 40007648
Sheet1!$1:$1048576 refers to every row in Sheet1.  Excel uses letters to define the columns and numbers to define the rows.

For example A1 is top left most cell in a sheet and XFD1048576 is bottom right most cell.

Referencing Sheet1!$1:$1048576 in effect references the whole sheet.  You could have used Sheet1!A:XFD also to reference the whole sheet.
0
 
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 200 total points
ID: 40007707
No points, please :)

>>Sheet1!$1:$1048576 refers to every row in Sheet1.

This is correct.

>>Excel uses letters to define the columns and numbers to define the rows.

This is correct if the default A1 notation style is in use.  There is however an alternative R1C1 style.
0
 

Author Closing Comment

by:Rayne
ID: 40007939
Thank you all :)
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question