Forum Discussion
Spydah
Nov 01, 2021Copper Contributor
Excel page break not working
I've created page breaks in Excel spreadsheets many times, but all of a sudden the feature isn't working in Excel 365. Any suggestions? I go to Page Break Preview, where everything is on the one pa...
- Mar 25, 2023
If use lookup vector sorted in ascending order and adjust result vector accordingly, simple LOOKUP(), which is available for any version, works
=F5*LOOKUP(G5&"-"&D5,{"µA-A","µA-mA","A-µA","A-A","A-mA","mA-µA","mA-A","mA-mA","μm-μm"},{0.000001,0.001,0.000001,1,0.001,1000,0.001,1,1})
HansVogelaar
Mar 21, 2022MVP
Spydah Perhaps Excel should display a warning if you try to specify conflicting settings, but I don't think it's a bug. The default setting for Width and Height is automatic. It requires manual intervention to change them to (for example) 1 page wide by 2 pages tall. By doing so, one effectively tells Excel to override other pagination settings...
strict_0fficer
Feb 08, 2024Copper Contributor
Yes I agree. Some message to indicate the existing over-ride would be quite helpful.HansVogelaar