Skip to main content

Hide Page Breaks in Excel.

Hide Page Breaks in Excel

  

Viewing page breaks is useful when using Excel. However, when you switch back to Normal view from a page break view, the page breaks will be visible as black dotted lines.  This can be really annoying.
To hide page breaks:
Excel 2007
  1. Click on the Office button in the top left corner.
  2. Select the Excel Options button at the bottom right side of the Office menu.
  3. Select Advanced in the left column.
  4. Scroll down to the Display Options for this Worksheet section.
  5. Uncheck the box marked Show Page Breaks.
  6. Click OK.
Excel 2003
  1. Go to the Tools menu and select Options.
  2. Select the View tab.
  3. In the Window Options section, uncheck the box marked Page Breaks.
  4. Click OK.  

Comments

Post a Comment

Popular posts from this blog

How to Enable Recycle Bin on Mapped drive.

Image
How to Enable Recycle Bin on Mapped Drive. Here is the solution for enabling Recycle Bin on Mapped Drive. I have tested it in My existing environment Windows Server 2019 and Windows Server 2012 and it's running fine.  Step 1. Press Win+R and type regedit and hit the enter key. Step 2. Goto " HKLM\Software\Microsoft\Windows\CurrentVersion\Explorer\FolderDescriptions " Step 3. Press Right Click on Mouse and Create New Key under FolderDescriptions and paste  " {9147E464-33A6-48E2-A3C9-361EFD417DEF} " as value. Step 4. After creating the key Right Click under  " {9147E464-33A6-48E2-A3C9-361EFD417DEF} " and Create New REG_DWORD-32Bit with Name = Category and set Value to 4. Step 5. Create New String with Name = RelativePath and set the value to Y:\  (Note: Replace volume letter Y with your existing letter. ) Step 6.  Create New String with Name = Name  and set the  value to YDrive Step 7. Goto " HKCU\Software\Microsoft\Windows\CurrentVersion\Exp...
Read more

How To Setup Internet Access Priority With Multiple Networks On Windows

Image
How To Setup Internet Access Priority With Multiple Networks On Windows If you are using multiple NIC's (Network Adapters) to access more than one network, it gets tricky from where you internet connection comes from. Here is one such scenario and solution to make Microsoft Windows prioritize internet connection from a particular network over the other. In my example setup I have one LAN connection (192.168.0.1) and one  WiFi  connection  (192.168.1.1) and would like Windows to use internet from my fixed-line broadband connected via LAN. To get started with configuring the internet access priority on your Windows computer, follow the steps below : Setup Network Card Priority at  Control Panel -> Network and Internet -> Network Connections -> Advanced menu –> Advanced settings . However, the above will not prioritize the internet access. To achieve that "Right-click on your  network  adapter " and click "Properties". Clic...
Read more

Fix: Documents Folder opens automatically at Windows Startup.

Image
Fix: Documents Folder opens automatically at Windows Startup Some often report this strange but quite annoying issue. While logging in to the computer, the Computer folder or the Documents folder opens automatically at Windows Startup . Unless you have placed its shortcut in the Startup folder, the most likely cause of this issue is the  incorrect or duplicated Usernit value in the Windows Registry. The fix for this problem does exists, but it requires modifying the registry. Serious problems might occur if you modify the registry incorrectly. Therefore, it is essential you follow these steps carefully. For added protection, back up the registry before you modify it or else create a  system restore point  first. Then, you can restore or revert if the changes are not what you expected. Documents folder opens automatically If when you start your  Windows 8  | 7, the This PC / Computer or Documents folder opens up automatically at start-up, first check...
Read more