![]() If you're not editing both columns A and Z of the spreadsheet while doing this, you could make a copy and then open both the copy and the original. The original question would be satisfied if two such splits could be present at the same time, but that appears to be not possible. ![]() To end the split-viewing function, drag the bar separating the window parts back to its starting position. In fact, you can do both, and have the window split into 4 parts. Unsurprisingly, you can do the same with the "split window" bar at the top of the vertical scroll bar, to obtain a part-window in which you can scroll through the rows while still viewing the fixed set of rows in the other part-window. ![]() This splits the window into two parts, each with its own scroll bar you can scroll either of them left and right without affecting the other one. When the mouse is hovering on it, the pointer becomes a vertical double line with left and right arrows. Immediately to the right of the scroll bar at the bottom of the window that displays the worksheet, is a small upright bar. Perhaps it's already well known but, if not, it will interest somebody, I suppose. It works in Excel 2000, so there must be a similar facility in later Excel versions. The following is not exactly what you are asking, but is partly equivalent. Or you could reverse it and say if A equals Z, do nothing, else put a *. Or not at allīasically, the first formula is is A not equal to Z, then put a * character, otherwise nothing. Indeed, if the spreadsheet is large and you think you might not spot all the "*", you can then filter to only display rows with a "*".Įdit to add that I was forgetting this forum displays unusual characters in unusual ways. I've used a temporary extra column, where I put a formula to show a "*" if A and Z are not equal I've had similar requirements - a need to check equal values in 2 columns more than 1 screen-width apart. Would it be possible to have the entire column coloured in red (or something similar) as soon as the checksum isn't zero? That way, I wouldn't always have to scroll to the end of the row in order to see if the numbers add up. I'd like to keep the same layout as a corresponding paper document, so moving the checksum to the beginning of the row is not an option. It consists of the sum of columns B-Y, the values of which I have to determine manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |