ZOOM Question

Mister H

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
Hi ALL:

I am having an issue regarding using the ZOOM on a report that is font:
Lucida Console 8pt

Sample of Data:

1st line in Cell A1 (ALL Text in 1 cell)
<TABLE style="WIDTH: 722pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=962 border=0 x:str><COLGROUP><COL style="WIDTH: 722pt; mso-width-source: userset; mso-width-alt: 35181" width=962><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 722pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=962 height=17>7251 Cash 16-SEP-10 CAD (3,315.97) 1 (3,315.97) 1 (3,315.97) (3,315.97)</TD></TR></TBODY></TABLE>

2nd line in A2 (ALL Text in 1 cell)
Balance for 1317911 ONTARIO INC (3,315.97) (3,315.97) (3,315.97)

The problem is when I have Zoom at 100% and the font as Lucida Console 8pt the numbers line up. When I zoom to say 75% then the numbers no longer line up? Why? Is the Zoom not just a visual thing? I want to make sure that the user can see both Columns A and B as they need to type comments in Column B but the data in A when at 100% takes up my whole screen. Any solutions?

HOPEFULLY this makes sense and you can recreate my issue with the data I provided.

THANKS for looking,
Take Care,
Mark
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Mister H

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
Hi Again :)

I just tried recreating the problem using a fresh sheet and I could not do it with the data I provided. When you paste my data from my post it does not seem to line up. If per chance you think you can assist and you want to provide your email address I can send you a sample to show what is happening. You can Post or PM me with your email if you can assist.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>

THANKS,
Mark :)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,421
Messages
5,528,676
Members
409,829
Latest member
CFreeamaz

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top