Excel headers and footers 101

Microsoft Excel has become an increasingly versatile work application catering to most businesses, big and small. While most users are familiar with all the functions the app has to offer, many are still unaware that you can add a header or footer to your spreadsheets. With that in mind, it’s time for a comprehensive view of what headers and footers are and how they work in Excel. What are headers and footers? As with Word, Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in an Excel spreadsheet. They often contain descriptive text such as titles, dates, or page numbers displayed in page layout views and on printed pages. Headers and footers are useful in providing quick information about your document or data in a predictable format and also help set out different parts of a document. Simply put, they make calculations, graphs, and pivot tables much easier to read and follow. How to add and remove headers and footers: Select the spreadsheet for which you want to add headers or footers. On the Insert tab in the Text group, click Header & Footer; this displays the spreadsheet in page layout view. To add a header or footer, click on the left, right or center of the Header or Footer text box at the top or bottom of the spreadsheet page. You can now add a preset header or footer to your document, or create a custom header and footer. To start a new line in a header or footer text box, press ENTER; to include a single ampersand (&) in the text of a header or footer, use two ampersands. When you are done, click anywhere in the spreadsheet to close Header or Footer. Return to Normal page view by clicking on the View tab and Normal button. To remove the header or footer from a spreadsheet, select the View tab and click on Page Layout. Delete the information you want to remove. The next time you need to repeat text on a page to make information more organized and easier to digest, you can simply do so with Excel’s header and footer feature. Looking to learn more about Microsoft Office and its features? Contact us today and see how we can help. Published with permission from TechAdvisory.org. Source.

5 common security issues

Security of your systems and technology is always an on-going battle and one you will likely never completely win. There are definitive steps you can take to ensure that your systems are secure, but we find that one of the most effective tools is knowledge. If you know a bit about how your systems can be breached, you can ensure a higher level of caution and security. To help, here are five common ways businesses see their systems breached. Read more...

6 Things to do when your battery is low

The laptop has become one of the more reliable tech tools at a business owner’s disposal. These mobile computers allow us to take the office with us when we are on the road. The only problem is, their usefulness often hinges on the battery power. If you have a laptop, it’s highly likely that you’ve experienced the battery running low while using it. Should this happen to you again, there are a few things you can do to preserve the remaining battery life. Here are six. Read more...

Finding apps on your iPad

The app is arguably the most important part of the iPad. After all, it is the apps that give the device it’s unparalleled usability and features. A common issue many users come across though is that they often have a large number of apps and it can be tough to figure out what apps you have installed, or even to find all of your apps. If you have had this problem before, here are three tips that can help. Read more...

8 data backup tips - Part 2

Regardless of the industry you operate in, or the size of your business, you should be taking steps to ensure that your business is ready for any disaster. While there are many paths you can take to ensure your business is ready, there is one element that is central to all plans: backing up your data. In the first part of this article, we took a look at four points that will help improve the effectiveness of your backups. Here are another four. Read more...