Home

fully ignoring the margin

Björn Burkhardt
New Contributor

Hi,

I wanna create an upright DINA4 excel-sheet with exactly 3 columns at the width of 7 cm.

You can see it here.

Ofcourse I deleted the margin in the options but it always creates this little gap or reduces the columnsize to less than 7cm.

 

Can you help me?

3 Replies

Excel is not a page layout program. Column width will be adjusted to the capabilities of the printer driver. Even with a margin of 0, the regular office printer will still apply a margin to a page. No printer can print right to the edge of a paper. Even industrial printers don't. These jobs are typically printed on bigger paper with a bleed and then trimmed to the exact size required. 

 

Can you explain what you are trying to achieve? Why are you using Excel for this?

löschen.png

I want to print 9 paper-"cards" out of a A4-paper piece.

Its important that they have a width of 7cm. The lenght can be among 9,9cm and 9,7cm.

So i thought it would be clever to create just a spreadsheet of 3x3 fitting a piece of paper. the inner borders are the line where you later cut out the "cards".

The margin around the edge of the paper will not be printed anyways but I need this framework for a 'perfect' cardsize.

 

I tried other ways, but realised excel is heavy buggy with that. I set a margin of 1cm. switched the B-colum to 7cm and the A- and C-colum to 6cm. In that way the framework should be still perfect BUT LOL switching the viewmode on excel back and forth (the 3 buttons in the bottom right corner beside the zoom) f*cked up the column size again. Try it on your won. The column sizes are changed for no reason. Even with the margin of 1cm and I reduce the column-size again about 0,0x cm on A and C excel changes it back after switching the viewmode.

What is your printer? What is the minimum margin for that printer?

 

Excel will always honor the printer minimum margin and you cannot go below that number.

 

If Excel changes the settings when you switch view, you need to work WITH the printer settings, not against them.

 

This will be so much easier in Word, or even Publisher.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies