LAN Systems
 
January/February 2011
Happy New Year!
 
From all of us at LAN Systems, we wish you and yours a joyous, properous 2011!
 
While making your New Year's resolutions, don't forget your computer system.  Use our easy update instructions to keep your Windows system secure and running at peak performance.
 
Mary

Updating your Microsoft Windows System

 

Protect your system by investing the time to update Windows. It is quick and easy.  In order to prevent attacks, you have to keep your computer updated.  Most infections are preventable and occur because of unpatched security holes.  Don't let your system fall victim, spend a little quality-time with your computer today!

 

Check your update status - Go to Microsoft Update and choose the Express option.Windows Update  This works for 99% of the systems.  It will evaluate your operating system status and recommend the necessary updates. Microsoft will identify the high-priority updates needed for your system. If you haven't updated your system recently, there may be several listed.  Be sure to apply all the recommended critical updates.  From this dashboard, you will be able to review your update history and get support. This is a good time to verify your backup or restore point. 

 

Turn on automatic updates - Windows Automatic UpdateIf your computer is not set to receive notifications when new updates are available, turn the feature on. You will see a screen message to "Help protect your PC" on the right-hand side of the Welcome to Microsoft Updates screen and can turn on the Automatic Update feature by clicking the box  Choose a time to install automatically or choose when you will manually install updates.  Critical updates may require a reboot so choose a time that your computer will be on but will not interrupt your work. You can also complete these actions from Control Panel. Screen shots are Windows XP, Vista and Windows 7 look a bit different.

 

For LAN Systems support customers, these tasks and checks are done for you but it never hurts to double-check your settings.  Updates are essential for your home system.  Most attacks are against home systems because they are more often out-of-date. 

 

For added protection, use Microsoft Security Essentials. Take a few minutes to update your system and if you have questions or need help, please feel free to contact us at 770 662-0312 or HelpDesk@lansystems.com.

Managing Rows and Columns in Excel Spreadsheets

Guest author David H. Ringstrom, CPA, www.accountingadvisors.com

Users often hide rows or columns in a spreadsheet to conceal private data, or perhaps just to keep a large spreadsheet manageable. This is a helpful feature in Excel, but Excelmany users often go about managing rows the hard way:

Excel 2007 or later: In the Cells section of the Home tab choose Format, Hide & Hide, and then make a selection as to what to hide or unhide.

Excel 2003 and earlier: Choose Row or Column and then Hide or Unhide, respectively. 

Hiding rows is fairly straight forward, as you can select the rows or columns, and then carry out the aforementioned menu command. To unhide rows or columns, you must select rows above and below the hidden section, or columns to the left and right of the hidden section, and then carry out the menu command.

Constantly navigating the menus to hide and unhide rows or columns can put unnecessary wear-and-tear on your wrists, but there are some easier alternatives. For instance, these keyboard shortcuts work in all versions of Excel:

· Press Ctrl-9 to hide a row or Ctrl-Shift-9 to unhide a row.

·Press Ctrl-0 (zero) and Ctrl-Shift-0 (zero) to  hide or unhide columns.

In both cases, make sure to use the numbers at the top of your keyboard, as opposed to the number pad at the right of your keyboard.

Many users are particularly bedeviled when they need to unhide selected rows or columns within a hidden area of a worksheet. Typically they unhide all rows and columns in the affected section, and then rehide what they don't need. Consider this surgical approach in all versions of Excel instead:

1.       Press F5 to display the Go To dialog box.

 

2.       Enter the address of the cell or cells that you want to unhide, such as A1 if you want to unhide a single row or column, D1:G1 if you want to unhide several columns, or A5:A10 if you want to unhide several rows, and then click OK.

 

3.       Use the keyboard shortcuts or menu commands I mentioned above to unhide the desired portion of your worksheet.

If you need to frequently hide and unhide sections of a spreadsheet, try the Group and Outline feature instead. First, select one or more rows or columns, and then carry out these steps:

Excel 2007 and later: On the Data tab of the ribbon, choose Group in the Outline section.

Excel 2003 and earlier: Choose Data, Group and Outline, and then Group.

Once you do so, a button with a minus sign will appear outside the worksheet frame. Click this button to collapse (or hide) the rows or columns. The minus sign will change to a plus that allows you to expand that section. Or use the 1 and 2 buttons at the top left-hand corner of the screen to expand or collapse all grouped columns or rows in the spreadsheet. To remove the outlining, select the grouped rows or columns, and then choose the Ungroup command on the aforementioned menus.

David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting and training firm. Contact David at david@accountingadvisors.com or visit www.accountingadvisors.com.

  eNewsletter 
Join Our Mailing List
In This Issue
Updating your Windows System
Excel Spreadsheet Tips
Network Group

Solutions and Services to help you grow your business

System and Network
Design & Installation

Microsoft, Linux and Unix
Servers and desktops
vCIO Strategy
Architecture review
System installation
Network security
Storage solutions
Virtualization
 
Service and Support
Support  agreements
Onsite services
HelpDesk support
System maintenance
Emergency services
Data recovery
 
Managed Services
24/7 system monitoring
Real-time notification
Automatic updates
Quickly fix problems
Alarming for critical events
System health reports
Follow up action plan
 
Data Backup Plans
Online combined with local or offsite storage
Easy to manage
Restore individual files or entire system
Safe and affordable
 



Special limited time offer 

PC Offer

 Only $450

10% Off MSRP $499.99

HP Desktop

Windows 7 Professional32-bit

505B Athlon II X2 220 (2.80 GHz)

2GB DDR2 RAM

250 GB

Offer good until January, 2011 or while supplies last. Some conditions apply.

 

Call 770 662-0312 or email sales@lansystems.com for more information or to order!