This is a fun and quick poll.
I want to know what is the maximum number of cells you can see when you open Excel. Do this:
- Open Excel, Maximize the window if it is not.
- Just tell me the bottom right cell that you can see completely.
- Go have a good weekend
PS: Make sure you set the zoom to 100%.
I will go first. I have 2 monitors.
On the large 24″ monitor, I see cell AC40 and on the 16″ laptop monitor I see S26.
What about you?
Just post the cell address in comments.
Check out previous polls.
PS: I am planning to use the poll data to make a visualization on how many cells you can see. So please respond.
330 Responses to “What is the last visible cell in your excel window? [Poll]”
U39 (laptop screen)
S25 (Laptop Screen)
S48, or O63 depending on my VDU. (desktop)
S49 (and part of T50) on my monitor at work and most of V44 on my laptop monitor (also at work).
S26. 14" Lenovo Laptop
T58
Screen resolution 1280x1024.
S45 on my normal monitor at work.
AM47 if I expand it across both monitors.
I use Excel 2007. Without minimizing the ribbon I see Z40 and after minimizing the ribbon I see Z44. Desktop - 22" wide screen.
S25
S30 with the Ribbon minimized
Subhash
D6, but I guess I should change my zoom setting down from 400. Wait, that's better...at a zoom of 10% I can see much much much much much more: FJ262.I hope this visualization of yours is going to have a log scale, Chandoo.
Otherwise, put me down for 025, or O30 if I minimize the ribbon.
X42 on my 17.3" laptop screen, X51 on my external monitor 20" both widescreen
and on my wifes laptop
S27 15.4" laptop
Work AC55
Home AC53
AG59 (23" widescreen)
U49
S51 - desktop; Excel 2003
Working with Excel 2007
Y39 on 22" LG Monitor at work.
Y44 with Ribbon minimized.
Q40 (desktop)
Q45, but
to make a comparison everyone should have the same dimensions for the cells. It's ok to take the new sheet, but with the same Font. I have Verdana 11
AC 43 on a widescreen desktop. AC 47 with ribbon mimised. Standard row height and default Calibri 11pt
Microsoft Office Excel 2003 (11.8302.8221) SP3
17" Monitor
1024 x 768 Resolution
L31
S27 with ribbon and S32 with ribbon minimised on LENOVO laptop.
Curious to see the visualisation with such a diverse range of data.
S32 (on laptop) - my font is by default Calibri 10
On laptop with 1280 x 800 px resolution
xl 2010: Q25
xl 2003: Q32
gotta check back at work for secondary 22" monitor. will be significantly different.
oh, and with ribbon minimised and formula bar reduced to 1 row (which I don't like in xl 2010: I have the formula bar to at least 3 rows so I can do long formulas and actually see them when the cell is selected -- so, anyway, without the fluff:)
Q33
cheers, teylyn
U30 (Excel 2007) for 1440*900 resolution on 15" monitor
S43 on laptop running on an old Elonex monitor at work.
AC42.
Excel 2007, Ribbon maximised, one row formula bar.
Monitor is 1920*1080.
I see cell AC40.
How to change default zoom in excel (quick tip)
1. Open a new workbook .
2. Change zoom
3. File>Save As a template file (xlt, xltx or xltm) in your XLSTART folder
Excel 2007 Template (xltx)
Excel 2007 Macro-Enabled Template (xltm)
Excel 97-2003 Template (xlt)
S27 on my laptop screen, V33 on external monitor
S38
U32 (laptop screen)
s38
i see O47
Excel 2003
19'' TFT
V34 using my default Office 2007 formatting.
AC55
With the ribbon on and one row on the formula bar
With Arial 8 font (changes the number of rows)
S26 (laptop)
At work (Excel 2007):
Ribbon Maximized Q29
Ribbon Minimized Q33
S37
19" monitor, Ribbon maximized, formula bar x 3 rows and QAT below Ribbon
Y49
S25 - laptop screen
AC39
S44
Somewhat impressive when you think about it...that's 836 different cells to work with!
V32 - laptop connected to monitor, 2007
Q30 (desktop)
S 28 (Laptop)
S42
19 inch with the ribbon minimized.
V32
M24, 1024 x 768, excel 03
S41 on one screen.
S32 on the other.
Excel 2007 - laptop S27 and monitor U32
O 25
Looks like I need a bigger monitor based on the monitor size others are showing!
Y40
S 38, Is there a way to change that?
28" lcd @ 1920x1200
ac63 in 2003
ac48 in 2010 w ribbon
ac53 in 2010 w/o ribbon
Q29 on DELL 16"TFT - Excel 2007
S48
Laptop, XL 2003: U41
Laptop, XL 2007: U39
v49 - laptop with desk monitor
X37 on 17" Laptop Screen
AC48 in Excel 2007 w ribbon
I think the video resolution determines the cell. Like garyk, I also have a 1920x1200 monitor.
U25 on my lappy if I'm running (yuck) windowz in 07.
W30 when I'm running 07 in WINE.
S37, I usually have the formula area expanded. If it's not expanded, S38.
S40 on my 4/3 17" screen.
Y38 on the 16/9 21" screen. these are with 2007 and normal ribbon.
Cell: O31
Excel 2003
19" Monitor 4:3 Aspect Ratio
Resolution: 1024 X 768
AM192
Excel 2007
30 inch Apple Cinema Display (connected to a PC)
2560 x 1600
Dell Desktop, 21" widescreen monitor 1920 x 1080 resolution:
Excel 2010 AB43, ribbon minimized AB47 (2nd monitor)
Excel 2007 AC40, ribbon minimized AC45 (1st monitor)
Excel 2003 AC52
15" MacBook Pro:
Excel 2011 U38, ribbon minimized U43
Excel 2008 R46
V39 on a 22" widescreen monitor @ 1680x1050 resolution, ribbon minimized
T25, on 13" laptop, Excel 2010
Maximized @ 100% on two 19" monitors; AM39
Effective Resolution of 2560 X 2048
S45
AS41 on 2 monitors effective size 1024 x 2960
A few quick measurements on my windows 7 machine with excel 2010
Left = 26 pixels
Right = 16 pixels
Minimised ribon = 94
Normal Ribon = 184
bottom status bar = 37
Windows 7 Task Bar = 41
Should enable interpolation on similar systems
S48 & P48 (2 screens)
Z39
At work (last full cell):
Main monitor: Y39
Secondary monitor: S39
Expanded across both: AS39
s27
Y39
AC49
Hope all is going well Chandoo..
O27 at work. Using a 19" monitor and Excel 2003
Q30
(RES 1440*900 with a 17" Widescreen Monitor)
P27
S49
S44
Y43
Have a great weekend !
Q45 Mac / numbers
S46 (Office PC)
O22
S47 17" screen
V32 - HP LA1905
V32
Cell U44 with zoom level at 100%, I can partially see V45.
AM48
O51 on Excel 2007 with the CRT set up in portrait mode.
S48
T35 on my Laptop
AB50
033
V32
22inch monitor. Excel 2003. See half of Z48
Z41
Y38 (external screen - 21")
U33 (laptop screen)
17 in monitor, Excel 2003 - O27
T32 on my work computer, using Excel 2003.
Z51 at a default of Arial 11 point font. (Changing the either the font or the font size changes the number of visible rows.)
AC39 - HP L1908wm / Zoom @ 75%
S27 on my laptop
S40 on my Desktop
I can see V30 on 19 Viewsonic display...... have a good weekend!
S44 (monitor) and S35 (laptop)
S36 on a 19" Dell with default cell sizes
Q43
W40
:
20.1'' Desktop Screen: AQ74
Y41
Excel 2007
1680X1050 resolution
21" monitor
S27
U46 MacBookPro - 11" width, 13" diagonal
X54
:
sorry!
it wasn't 100% It was 60%
now it is 100%
it is Y44
s33
Z40 22 inches display resolution 1680*1050
O31, but that's with a lot of toolbars open. Excel 2003
P31
O27
S39
I have 2 laptops: 1.) 17" T31 2.) 15" T25 - on 100%.
O28 (Laptop)
L32
S27 on my laptop.
Y41 on my widescreen monitor.
Love your work Chandoo. You are awesome.
AC41 @ 100% Zoom
S37
031
Excel 2003, IBM T43 laptop
U32
o26 (laptop)
Y38 (desktop at work)
Q36
DELL DESK TOP
L45 : 19 inch monitor
U32
AC47
AC57 (24" screen) with zoom level at 100%
Embarrassing 15 inch monitor O26.
BK99 (laptop), but rather difficult to read ....
U32
S48, XL2003, 1280 x 1024
I see AL 73
Excel 2007
19"
In Excel 2007, S37, but S41 if I minimize or hide the Ribbon, and S42 if I minimize the Ribbon AND my Quick Access Toolbar. ~mp
S49
well, if you want to include spanning, across my 3 monitors i see ck61.
S35 on a 19" Monitor.
S48 on single monitor, AM47 stretched across dual monitors
That's Excel 2003, on 2 17" monitors, both with screen res at 1280x1024
T25 on a HP probook 4410s laptop
Q37
S25
N27 on my laptop running Excel 2010
Q42 on my trusty 19" CRT on the PC running Excel 2000
AC51 (22" Work)
w44
Z38
S38
U35
I'm using
Excel 2003
Widescreen Laptop
S46
S45 on my 19" Gateway and V40 on my 19" Lenovo widescreen.
T25 (Excel 2007) Laptop
T38 with laptop in docking station 22" monitor
V31
U46 on 1280x1024 resolution
S27
S37
AR 60
ouch L25, excel 2007, waiting to hear some tips about how te see more.
S38 (laptop)
V37- Laptop
X47
Resolution 1600x1200 on Viewsonic 2130b
X45
S28 15.6 laptop
O31
15,4" Lenovo Notebook
1280x800
Excel 2010 beta w/o ribbons
S60 - 20 inch IMAC
BR80 - Excel 2010
2 x 30" Apple Cinema Display 5120 x 1600 (WinTel)
P43
AE46
Y-39
S27 Laptop
different cells with different font size:
Ariel 8 --> O41
Ariel 10--> O36
Ariel 12--> 031
This is Dell laptop "inspiron 640m"
Z47
two screens S38 on one, S39 on the other...
On my work laptop screen: S27 (1280x800)
On my second monitor: X49 (1600x1200)
Note that there is no taskbar on the secondary screen (probably a row's worth), and if you minimize the ribbon you can gain another 4 rows. I'd have to check the screens I have at home.
A 113 comments for this post!
Way to go dude - way to go!
Congrats! you have them eating from your hands.
V54, home computer screen. However, I made my default font calibri in size 8, to increase visible cells.
V221
N25
U33 - laptop
S37 Normally (19" 4:3 LCD)
S44 Taskbar and Ribbon minimized
Curiously, P28
S37 - Work computer.
M46 using Office 7
V32 desktop.
S24 - Laptop
AC64...HP 25.5" Arial 8
laptop: S27
monitor: S36
S35
AC40 27" 1920x1080 res
AD55, 25/5" 1920x1200 res, my default zoom is 85%
V37
with ribbon minimized on Excel 2007
V31
AC47
P26
i have opened 2 Workbook
In first i got O46
In Second i got K34
L25 netbook
AF71
Have 2 22" screens
S34 - Toshiba La[top
U39
N31 . . . but I use a default column width of 12.
A1.
Just kidding. X34. I have a 1600x900 17" monitor on my laptop. Screen res is set to max.
S27 on a 13.3" screen at 1280x800 resolution
S32
s26 laptop
AC41 --- 24" monitor and using excel 2007
S31, Lenovo X201 laptop screen, Excel 2010
T24 Acer 16"
P19 - laptop
025,on a 12' Dell Laptop
V41 om dell D620 work laptop, Excel 2003, 1440 x 900 res
S39, but with Excel across my dual monitors I can see AM39.
O 21
Wow... this is the biggest thread ever and the responses are still coming. Thank you
z63
dell u 2410 (x2)
if i use both monitors it would be ba63....
(ba69 without ribbon)
do i win sth now?
S38 at home using Excel 2007.
Will check work PC (Excel 2003) on Monday.
S26 on HP 6530s laptop
Good luck tabulating all the data!
with / without Ribbon. XL 2007, default resolution, Calibri 11pt.
W40 / W44 Desktop screen 1, 1680 X 1050 eizo S2110W
R84 / R89 Desktop screen 2 1920 X 1200 HP L2475W Portrait mode (my default for this screen)
AC49/ AC53 Desktop screen 2 1920 X 1200 HP L2475W in Landscape mode
W49 / W54 Dell Vostro 1700 laptop 1920 X 1200
L22
W30 I'm using a Vaio laptop, about a 17" HD monitor. Chandoo, what an interesting clever Poll.
S38 17"Monitor
t40, 16'' Monitor
Samsung 22" (1680x1050): Y42
Projector (1920x1080): AC45 (AC46 is fully visible but not the bottom border)
Y39
doesn't column width and row height of excel file open make a big difference in survey results....if all had columns width at 10 and row height of 15, then results would be more relevant
S40 19" monitor
O25 with Excel 2007 on IBM X41 laptop
AF52
23" Widescreen
2048 X 1152
100% zoom
Ribbon visible
QAT below ribbon
status bar and formula bar visible
Windows taskbar hidden
V32 on a HP 19" monitor
AL80 or AL85 (with or without ribbon) - Excel 2011 on a 27" iMac. Font is the standard Calibri 12, zoom at 100%.
AM90 if I choose Full Screen Mode.
@mike@tahoe
The screen cell size depends on the Pixel size of the screen and the default Font and Font Size
Using the Standard Calibri 10 Font of Excel 2010 at 100% I get AC53
At Arial 6 point 100% Zoom I get AM90
W43 with default settings in Office 2010, 23 inch full HD monitor
Q39, 17", 1152x864 px
U31, 11.6", 1366 x 768, Excel 2003
R26, 1280 x 800
S38
Excel 2003: S33
Excel 2007: S32
Both have same default settings - font: Arial 10; column: 8.43; row:12.75
laptop: Dell D630
AC47, 1920 x 1280, Excel 2007
Work computer running Excel 2000
3 rows of toolbars at the moment
Laptop screen (Dell Latitude D630) with 1280 x 800 pixels = Cell V31
Additional monitor (Dell 2007FP) with 1600 x 1200 pixels = Cell AA59
AC59 full, AC60 about 4/5ths of its height. 24" HP monitor LP2465.
T27
X58
I also replied to your email. oops it has been a long weekend...
Take care
x37 on 20" monitor
AF66
(24 inch screen - I have font size set to 8 point Arial)
S38
Microsoft Office Excel 2007 O25
Dell 17? Monitor
S49
(Arial 10 and 100%)
S27 and in minimised ribbon S31
O25 (Excel 2007)
Y42
Y39
Desktop screen Q38
Z38, have fun analysing...
AC50
X58
S45 on my 19" work monitor.
O33, on laptop 1024x768 px
Y37
S50
Laptop PBLJ65
17" Screenresolution 1600x900
Font Calabri 11
Fullscreen X41
With ribbon X33
V33 on laptop 14" resolution 1440 x 900
ACER V223W monitor - cell Y38
ACER AL1916W - cell U32
S45
(normal monitor at work)
S25
U25 (14" Laptop)
O28 Primary monitor
O32 Secondary monitor
AC43
S27
S34 with the ribbon minimised
S32 Excel 2007
S45
R 34
and R40 with the ribbon minimized
P51 - Desktop 17" Monitor, Excel 2003, Taskbar hidden.
Q47 Excel 2007
Z48 - Desktop computer with Excel 2003
S34
S27, laptop screen
S46 on one 1280x960 display, AM46 stretched across two identical displays.
S27 on a laptop screen
S33 on desktop
u41, Excel 2011 on MacBook Pro
U25; with ribbon open
(100% zoom level)
S38
Q49
S45 on my normal monitor at work with the ribbon in Excel 2007
Excel 2007 - 22" desktop monitor @ 1280 x 1024 S45
V32
[...] weeks back I ran a poll asking you to tell me what is the last visible cell in your excel window. It was a casual poll. So I didnt expect a lot of responses. But, boy I was wrong! 295 of you have [...]
AX53
2 x 22 inch monitors
U48
V57
AD42 100% view
S40
W40 on monitor 1
S32 on monitor 2
XFD1048576
S34 1440 X 900 on 17" widescreen w/Ribbon off and Google sidebar on
it is S25
Q49
It is AC41
AC47 16" full HD laptop
S34 (Without Scrolling) , 100% Zoom, HP Laptop (14").
X50 - 27" widescreen
O31 - Laptop
AC58 wide-screen laptop - Excel 2003
S24
SAMSUNG SynchMaster 930B (19"):
normal ribbon: S37 (S38*)
minimized ribbon: S42 (S43*)
* Quick Access Tool-bar above
Late to the party, but here is some data FWIW
x61T laptop screen at 1400x1050: U44
Dell 2005FPW 20.1" LCD at 1680x1050: Y45
[...] 31 posts had more than 50 comments each. The maximum comments were 313 on the last visible cell poll. [...]
Even later to the party.
T39 - on a single SyncMaster 920N (1280x1024)
AM40 - if stretched over two SyncMaster 920N's (1280x1024)
AC42 on my primary screen
V32 on my secondary
O32
O25
AC41, just installed a 24"Asus
U34 on laptop
hp 500, S33
S50
s27, sony vaio
u36
BG48
Excel 2010 on 2x Dell P2411H monitors (1920x1080 ea)
Effective res 3840x1080
According to me we can see IV65536 number of cell....for that we have to reduce cell & Column size to 1 pixel n zooming size to 10% ( but which is very difficult to see the cells (i.e IV65536 cells)
The last cell I see using an iMac 21.5' is AC 70
AQ43- macbook