On June 30, 2014 at 00:20, bcf1963 said...
I'm pretty sure the issue... is the template you've chosen.
The scroll bars will always show to the extent of any information entered into the sheet.
It is highly likely the person who designed the template, designed it for someone to puts lots of lines in the sheet, and have any macros / formulas work. To do so, they likely put something way down... likely at line 14,372.
I agree with you that the sheet most likely has at least one column that was selected with all rows for table for data formatting.
It should be fairly simple task to highlight the actual table (38 rows) and copy/paste special into new sheet, provided that the file doesn't have protected sheets/workspace or special macros.
The bigger issue, is who uses a spreadsheet to make out a grocery list? With a pencil and paper, I typically do this in about 5 minutes. First I write in the upper right of the sheet of paper the meals being made for the week. Next you go through what ingredients needed for each meal, and if those are present in the refrigerator / panty, and if you need it, it gets put on the list. Making a week full of meals, this is typically less than a 5 minute task.
With a spreadsheet, how does this take? 20-30 minutes? Yeah... great use of time. OCD guy... I suggest you go alphabetize your spices.
This statement is ignorant. I can think of at least t reasons why softcopy is better than pen & paper.
