- Local time
- 8:00 PM
- Posts
- 52
- OS
- Windows 10 physical Windows 11 virtual
I have an Excel Workbook with two sheets. The main page lists items. The other page has each item listed with info under each, about 4 rows for each.
I link from the main page to the item sheet, no problem. Works well.
But for items further down on the item sheet, I could not put in the row and column as this was greyed out.
So I would have to scroll down on the Item sheet to get to the one I wanted.
I discovered setting the print area was causing this.
In fact when creating the link and choosing, it actually said Item print area.
So I deleted the set print area and I could now put in the row/column and go directly to it from the main sheet.
I know I could define an area, but for more than a few items, this would be tedious.
Is there a solution besides deleting the print area?
Thanks.
I link from the main page to the item sheet, no problem. Works well.
But for items further down on the item sheet, I could not put in the row and column as this was greyed out.
So I would have to scroll down on the Item sheet to get to the one I wanted.
I discovered setting the print area was causing this.
In fact when creating the link and choosing, it actually said Item print area.
So I deleted the set print area and I could now put in the row/column and go directly to it from the main sheet.
I know I could define an area, but for more than a few items, this would be tedious.
Is there a solution besides deleting the print area?
Thanks.
My Computer
System One
-
- OS
- Windows 10 physical Windows 11 virtual
- Computer type
- PC/Desktop
- Manufacturer/Model
- Custom Built
- CPU
- 12
- Motherboard
- Asus
- Memory
- 128
- Graphics Card(s)
- Nvidia
- Screen Resolution
- 1360x768
- Hard Drives
- 2
- PSU
- 850
- Case
- Cooler Master
- Cooling
- fans
- Keyboard
- ergonomic
- Mouse
- wired
- Browser
- several
- Antivirus
- abast
