-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
leftmost
-
S
VIEWABLE, not VISIBLE!
Hi Guys.... Does anyone know a way to discover which is the rightmost column IN VIEW in a Window showing an Excel Worksheet with column A as its leftmost column? I'm visually impaired, so I use a low resolution, and normally I can see col L with Excel in full screen mode. I'm trying to use...- sts023
- Thread
- column excel leftmost visible window
- Replies: 4
- Forum: Excel Questions
-
J
Sumproduct or countifs when using left function over an array
Pardon my ignorance but I'm struggling with this one! I have an dataset as shown below: <tbody> A B 1 77+ 77 2 98- 88 3 66= 66 4 55+ 66 </tbody> The formula I would like to crack requires comparing the leftmost digit from column A to the leftmost digit in column B over the array and...- jblonde002
- Thread
- array column digit leftmost target
- Replies: 5
- Forum: Excel Questions
-
R
Freeze a certain row to the top when scrolling down to it?
Hi guys, I am new to Excel and I am wondering if there is a way to freeze a row to the top when you scroll down until it becomes the top row? For example, I want to see row 50 frozen at the top only after I scroll down and row 50 comes on top. I only know that we can freeze top rows or...- RicoJ
- Thread
- freeze leftmost row scroll top
- Replies: 1
- Forum: Excel Questions
