I wanted to print a worksheet in Microsoft Excel. An error pops up “Print titles must be contiguous and complete rows or columns”. What can be done to get a solution for this problem?

I have read the Terms & Conditions

Login with:

Already a Member? Sign In

email address

Password

Remember Me

Forgot your password?

New to Ask iYogi
Sign Up!

Enter your OpenID URL

http://

Proceed

Enter your WordPress.com blog URL

http://.wordpress.com

Proceed

I have read the Terms & Conditions

Login with:

Sign Up



E-mail
Password
ReType Password

By clicking on "I Accept. Sign Me Up" button below, you would agree to our Terms & Conditions.

Enter your OpenID URL

http://

Proceed

Enter your WordPress.com blog URL

http://.wordpress.com

Proceed

iYogi, Inc. BBB Business Review

Welcome Guest !
Sign up
|
Sign in

maxpaik

I wanted to print a worksheet in Microsoft Excel. An error pops up "Print titles must be contiguous and complete rows or columns". What can be done to get a solution for this problem?

asked on 10th Aug 2011 | 1 Answers | Answer It!

uttam

answered on 10th Aug 2011 | |

Which version of Excel are you using? I am providing you instructions for Excel 2007 and above. Go to Page Layout - > Print Titles > Sheet : Cell errors as : chose and then click OK.

Here’s to Good Karma

Log in to reply

More Q & A, Solutions and Videos

In a Microsoft Word 2007 document how can I add borders to the pages?

asked on 14th Sep 2011 | 1 Answer

I couldn't stand the new Microsoft Word so I started using Open Office. It seems to be a little simpler but I have one problem. I cant figure out how to close up the spacing between lines. The damned thing is double spacing everything.

asked on 6th Aug 2011 | 1 Answer

I am getting in all applications in office 2007 , error is “Connecting to the Microsoft Office Live Workspace beta failed due to an unexpected error. Try again later”

asked on 29th Jul 2011 | 1 Answer

I get an error when I try to install mappoint 2010. It will not start saying that it is not capatible with Windows 7 64.

asked on 5th Aug 2011 | 1 Answer

My printer just refuses to print a document in Microsoft Word 2007. Earlier it was working correctly…can't understand what's the problem now.

asked on 12th Sep 2011 | 1 Answer

I had RAM issues with my windows 7 computer which I managed to fix. But in the process, I installed a lot of programs that were supposed to be helpful but they have messed up my media players. While windows media player won’t play(it just flashes and disappears), media center just crashes if I try to play a video or music. If I try to start it by double clicking an audio file, I get the "Server Execution Error" message.I do not want to uninstall windows 7 and reinstall it just for this.

asked on 14th Jul 2011 | 1 Answer

Is there a keyboard shortcut for the format painter button in excel? I use it a lot.

asked on 1st Aug 2011 | 1 Answer

I have Windows Vista installed on my computer. I am facing this problem that MP4 videos do not show in Windows Media Player 12. Someone suggest a solution for this.

asked on 23rd Aug 2011 | 1 Answer

I put a password in my word file and now i forget that. Is there any way to recover that password? It's very important file for me. I have created this file in word 2007.

asked on 10th Jun 2011 | 1 Answer

When I print a Word 2003 document with highlighted text, the highlight color does not appear in the printed doc. My computer has the Windows XP operating system.

asked on 25th Aug 2011 | 1 Answer

will answer your tech questions for FREE
Here's to Good Karma