- Weekly Tip Home
- Change Recycle Bin settings in Windows 7
- Windows 7 Features - All Editions
- Prevent Windows Update from automatic reboot
- How to Configure a User Account to Automatically Log On ?
- How to change start button icon in Windows 7 ?
- Disable the Windows Startup Sound.
- Windows Sysinternals Suite for Windows 7
- Turn on/off Windows Features
- Windows 7 Calculator Keyboard Shortcuts
- Change Windows 7 Numbers, Measurements and date Format
- Windows key shortcuts for Windows 7
- Open Windows 7 folder with Shell command
- A List of Run Commands For Windows 7
- Find Windows 7 Problem Reports history on Your PC
- Make Internet Explorer 8 Load Faster
- Windows Explorer Keyboard Shortcuts for Windows 7
- Learning About Your Own Account with Whoami in Windows 7
- Automatically Delete Temporary Files using batch script in Windows 7
- Save Hard disk Space by disabling memory dump files in Windows 7
- Make Windows 7 Shut down Faster
- Increase Windows 7 PC Memory (RAM) with your Flash drive
- Understanding Disk Management Terminology in Windows7
- All about VHD (Virtual Hard Disk) in Windows 7
- Administer your Windows7 PC using Microsoft Management Console (MMC)
- Types of Stop Error on Windows 7 PC
- Enable the hidden Administrator account in Windows 7
- Managing Installed Drivers in Windows 7 PC
- Cracking Hardware Errors in Windows 7 PC
- Command-Line (CMD) Editing Keys in Windwos 7
- Display Empty Removable Drives
- List of inbuilt applications you would like to replace in Windows 7
- Enable GodMode Feature on Windows 7
- Make your Windows 7 talk
- Make folder and content within undeleteable and only accessible to yourself in Windows 7
- Hidden Utilities and Shortcuts in Windows 7
- Create keyboard shortcuts to your favourtie application in Windows 7
- Show additional time zone in your Windows 7 taskbar
- Auto Login to your Windows 7 PC
- Install Telnet with only one command in Windows 7
- Open Command Prompt From Any Folder in Windows 7
- Automate Powershell script to find high processes running on Windows 7 PC
- Check RAM issues with Windows Memory Diagnostic tool in Windows 7
- Show your downloads on Windows 7 start Menu
- Unlock new themes in Windows 7 PC
- Use Windows 7 Without Activation
- Turn off Autoplay Feature in Windows 7 with one Click
- Running Disk Defragmenter from command line in Windows 7
How can I hide columns or rows in a worksheet ?
What is it ?
Excel allows you to easily hide columns or rows in a worksheet. Once a column is hidden, it will not show onscreen or print. The column is not deleted; its width is simply reduced to zero (0).
How do i do it ?
To hide a column:
1. Right click the column header that you want to hide.
2. Click Hide from the pop-up menu.
The column is hidden.
Adapt the above method to hide a row
To unhide a column:
1. Select the columns on either side of those that are hidden.
2. Right click a selected column header, then click Unhide.
The column is unhidden.
Warning – Do not use the hide method as a means of securing confidential information. All hidden rows and columns can be easily unhidden by anyone who has access to the spreadsheet. To secure confidential
information, use security internally. If sending externally, hide the appropriate rows or columns then convert the sheet to a PDF, ensuring password protection is applied preventing copying, extraction and
changes.
BACK to what is it ? How do i do it ?
- 06/08/2010 06:52 - What is network drive ? How can i create batch file to map network drive ?
- 31/05/2010 05:56 - What is Bookmark ? How do i add a bookmark in my word document ?
- 20/05/2010 00:40 - How can I create shortcut to different exe and msc file with ease, so that I can run these program with administrative account ? (Windows XP)
- 03/12/2009 02:47 - What is Outlook Rules ? How do I create one ?
- 24/11/2009 04:34 - What is envelope icon in outlook? How do you show it on notification area?
- 11/08/2008 17:18 - How to reduce outlook mailbox size by clearing the conflicts folder
- 11/08/2008 17:14 - How can I Print Comments adjacent to the related text in the document ?
- 30/07/2008 14:06 - How to empty outlook deleted items using Blackberry
Last Updated (Thursday, 28 January 2010 04:23)
Back



