![]() |
#1
|
|||
|
|||
![]()
I use Excel to post client account records, some of which are many screens long. Every time I reopen Excel to make a new entry on a worksheet, it has defaulted to the top and I need to scroll down to the point to make a new entry manually. Doing a Ctrl-End sends me to the absolute bottom of the file's potential limit. Is there a way to change this default to simply leave the worksheet at the point it was saved?
|
#2
|
|||
|
|||
![]()
If I am working at row 456, save the file and close it and after that open it, it will open there where I was when I saved it, in this case Row 456.
It doesn't do that for you? |
#3
|
|||
|
|||
![]()
Can it be that your workbook contains a Workbook Open macro that sets Excel open at the top?
|
#4
|
|||
|
|||
![]() Quote:
I converted, or I should say Excel automatically converted, these files from Apache Open Office, but I never had the issue there and I haven't created any macros or done anything w/ Excel 2016 on-line since I began using it a few months ago. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore | quanghuynguyenhua | PowerPoint | 0 | 10-10-2015 06:17 PM |
I can open an email which has characters such as [ ] in the path but if i close and reopen it i get | Davederave | Outlook | 0 | 09-25-2015 07:04 AM |
![]() |
Attila | Word VBA | 3 | 01-29-2015 04:08 AM |
![]() |
samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
Word loses image sizing when I reopen file | rbz1949 | Drawing and Graphics | 4 | 06-24-2010 11:19 AM |