Why Does Column J Appears Despite Adjustments in Excel?

happydz

Board Regular
Joined
Jan 11, 2017
Messages
62
Office Version
  1. 2010
Hi everyone,I’m encountering an issue in Excel where column J continues to be visible, despite taking the following steps:
  1. Set the column width to auto-adjust.
  2. Cleared all content from column J.
  3. Adjusted page scaling to fit the content to one page.
Unfortunately, column J still appears.

Things I’ve Tried:​

  • Cleared all content (including formatting) in column J.
  • Checked for conditional formatting or hidden spaces.
  • Adjusted margins and scaling settings.
None of these solutions have resolved the problem. I’ve attached a screenshot for better understanding.

Questions:​

Has anyone else faced a similar issue? How can I ensure that column J doesn’t appear?
P.S.: While I know I can manually adjust column I by dragging it to the right, my concern is that I used to achieve a one-page fit by adjusting margins and scaling settings (with auto horizontal and vertical centering). This time, however, it's not working as expected, as shown in the attached screenshots.
Thanks in advance for your help!
 

Attachments

  • screenshot 1.JPG
    screenshot 1.JPG
    160.4 KB · Views: 16
  • screenshot 2.JPG
    screenshot 2.JPG
    117.9 KB · Views: 16

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Have you checked if a Print Area (including column J) has been erroneously set ?
 
Upvote 0
Thank you guys for your help, I just used >Imprimer>Mise en page >Page>Adjust the Echelle % and it's fine.
 
Upvote 0

Forum statistics

Threads
1,225,138
Messages
6,183,083
Members
453,146
Latest member
Lacey D

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top