Top Answer
User Avatar
Wiki User
Answered 2011-11-25 11:44:00

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

Your Answer

Related Questions

You do not. Row headings always are numbers. Of course, you can create your own row headings to display when you print your report, just enter them in column A.

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.

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.

In the Print Page Setup window, select the Sheet tab and click on the Gridlines box in the Print section.

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 2003 and older: File menu button Excel 2007 and newer: MS Office button (circle at top left of window)

The Purpose of Bold TypeBold should be used on Titles, column headings, section headings, and for emphasis. The word "bold" in the previous sentence blackened for emphasis. Above it, I created a "title" and used bold to make the title stand out.

The Print Layout tab has all the settings relating to pages, such as margins, page size, orientation, ability to view or hide gridlines and headings, scaling etc.

The area you have set up to print.

There are various ways to print an Excel file. From the file manager (explorer), select the file, right click and choose print Open the Excel file - Press Ctrl + P to print - Choose File from the top menu, Click Print - Click the Printer Icon from the Toolbar Hope this helps Rohini

Column and Row titles are on a worksheet by default. They can be hidden or shown in the View tab of the Options setting. They are not there by default when printed. You can add them in for printing on the Sheet tab options of the Print Setup.

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

MS Excel does not have the ability to selectively print odd or even pages. You need to use the function on your printer for that option. When you print from Excel, instead of just clicking the print button, select print and click on the printer PROPERTIES button. If your printer has the ability to selectively print odd or even pages, you will select that option according to your printer's specifications.

Highlight the area you want to print. Go to the print menu and click on the selection option.

-captions -photographs -close up/zoom -glossary -headings -table of contents -title -bold print -color print

Ctrl - P will open the Print dialog box.

AnswerTake for example the EXCEL. after creating the object of the excel sheet and performing the operation on the excel sheet, you want to view the print preview.Object.PrintPreview This will show the print previewObject.PrintOut Thsi will directly print the document instead of priview as it is to the default printer.

The results of formulas that you type in are outputs in Excel. If you do filters, the results you get are outputs. Charts are an output. If you print anything from Excel, that is an output.

When you print a worksheet or use the Page Setup dialog box, Excel inserts_____ breaks that show the boundaries of what will print on each page

First select the area of the worksheet that you want to be your print area. Then in the Page Layout tab you will find the Print Area button, enabling you to set it. On versions of Excel before 2007 it is in the File menu.

No, comments are not printed by default.

Copyright ยฉ 2021 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.