answersLogoWhite

0

to get column number, we can use =COLUMN(Reference)

to get Row number, we can use =ROW(Reference)

For example =COLUMN(A1) will return 1 and =ROW(A3) will return 3

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is a print title in Excel?

It would be information that appears on every printed page from column or rows. You might have headings and want them to appear on every page to help you know what the data is in each column and row.


What will happen if you check the row and column headings option in the sheet tab of the page set up dialog box?

The row and column headings will be on the pages that you print.


How do you print a graph paper in Excel or word?

In Excel, you can set the column width to 2 and display borders around the cells of the number of cells you would like to display on your graph paper, then print.


I have created a worksheet in Excel and only want to print Columns A and G. How do I do this?

To set the area of an Excel worksheet that will be printed select the range that you want to print and go to the File... Print Area... Set Print Area menu. You can also hide columns that you don't want to see on a print-out by right clicking on the column header and selecting Hide.


Excel does not display the print dialog box shown ion the accompanying figure when what is used?

in windows what is the window file something?


What button opens a menu of basic commands such as save and print in Excel?

Excel 2003 and older: File menu button Excel 2007 and newer: MS Office button (circle at top left of window)


How do you print excel data?

press print!


Looking at titles, headings, bold print, and pictures is an example of?

Surveying


What shows you how the worksheet will appear when printed in excel?

Print preview.


What is a column header in Excel?

Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page of a spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers. They are used to add information to a spreadsheet that is being printed. Information about how to use headers and footers in Excel is included in the related links.


What instructs Excel to print the selected range?

Print to file check box.


What is Marco in Microsoft Excel?

A macro is a more complicated form of coding than a formula. Formulas enable you to add two columns of number into a third column. Macros will take the third column of numbers and update a diagram, save the results and print the diagram for you