Maybe I not understood your question exactly... (and there are too many questions for one topic...)
1. How do I have a tab show only the columns/rows I am working on?
- When you click print and didn't highlight and it wants to print 455 sheets of blue and white lines.
The AOO and LO shows the non empty cells in the Print Preview. If you want to see only the wanted cellrange in the Print Preview, then you need adjust the Print Ranges on every Sheet: Format - Print Ranges - Edit
Set the "none" option if you want not print a specific sheet
2. How do I lock the cell color?
- I have made every other row a color so it's easier to keep one job on the same line.
The cell properties (like the background color) will be trasferred from cell to cell by a normal copy/paste, cut/paste method. Solutions and workarounds:
- Copy and paste only the cell content but not the formatting properties. Use the Paste Special feature.
- Use Cell styles instead of the direct formatting. Then you will able to fix easier the "damaged" format properties by re-applying the desired Cell Style.
- Try to use the Conditional Formatting feature based on the Row Number. You can apply the relevant cell style for the odd/even rows automatically.
3. How do I lock certain cells?
- Some cells on the invoice have text that I never change
.
Use the Protect feature. You can switch on/off the protection for every cells and for every sheets individually.
4. How to move from one cell to another?
- After I enter an amount into a cell I want to hit enter or tab and have it take me to the next cell I need to enter text in. How do I bypass empty cells?
Workarounds:
- Use the arrow keys to move the cursor into next input cell.
- Re-organize your input range to one continuous block.
- Use the cell protection (against the accidental modifying the cell contents).
- Use the Data - Form feature for entering data into a cellrange.
