answersLogoWhite

0


Best Answer

The below is true (CTRL-downARROW) if there are no breaks (blank cells) in the column or row in question. The end of the sheet is actually determined by pressing CTRL-END.

Normally, what EXCEL thinks is the end of the data may not be the same as the actual end. For example: Let's say your sheet has no more data after COLUMN-H, ROW-100 (=H100) - But when you press CTRL-END, you are taken to a cell much further down (for example: =H349)

Good news: The end of the document may be RESET by selecting the cell you want to be the END (like H100). Make a MACRO with the following and execute it one time and the end is now reset. Any time there's an issue like this, the macro will take care of it.

Sub RESETrange()

ActiveSheet.UsedRange

End Sub

Daniel L

-----------------------------------------------------

You can get to the end of the worksheet in Microsoft Excel by holding the Control button down, and then the 'down' button on your keyboard. This will take you to the vertical end of the worksheet. If you want to go to the horizontal end, use the 'right' key instead of the 'down' one.

Essentially, use the arrow keys in combination with the Control button to go to the extremity of the worksheet in that direction.

The 'highest' cell reference in Excel 97, 2000, 2002, and 2003 is IV65536 (column IV, row 65536). 65536 is 216.

In Excel 2007, these limits are upped much further, to XFD1048576 (column XVD, row 1048576). That is 1048576 rows (220), and 16384 columns (214).

Simply in the name box type the last cell address for go to the end of MS Excel last cell

or press F5 key for Go To Dialogue box.

to find the size of the sheet click over the intersection of Row number and Column Label and view the size of the sheet in the name box

SANJAY KISHORE

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you get to the end of Microsoft Office Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


Is Microsoft office Excel 2007 a presentation program in Microsoft office 2007?

No. Excel is a spreadsheet application. Powerpoint is a presentation program that is part of Microsoft Office.


What other program is similar to Excel in Open Office?

Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice.


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


What software is used in a spreadsheet?

Microsoft Excel.


Microsoft Excel is the member of what family?

Microsoft Office


Does Microsoft Office 2000 have Microsoft Excel?

Yes it does.


Is it necessary to download Microsoft office before you download Microsoft Excel?

It is not necessary to download Microsoft Office before downloading Microsoft Excel. Excel is part of the Microsoft Office suite of programs, but it can be downloaded independently from the Microsoft Office suite. If you need the entire suite of Microsoft Office programs, then downloading Microsoft Office is necessary. However, if you are only looking to download Microsoft Excel, then you can do so without downloading Microsoft Office. For downloading Microsoft Office, the best website is Microprokey .com It has the latest version of Microsoft Office and offers competitive prices. It also offers discounts on different versions of Microsoft Office and has excellent customer service. Don't Mis 30% Off Coupon Code: MO30KEY


What is a correct way to gain access to Microsoft Excel?

You have to buy it. Go to the Microsoft website and download it from there.


Where is MS Excel?

MS Excel is under Microsoft Office


Is Microsoft Excel the database software of the Microsoft office suite?

No. Excel is a spreadsheet. Access is the database.


Is Microsoft word a part of Microsoft office?

Yes just like PowerPoint