LJC Webhosting

Website Design in Pembrokeshire

  • Facebook
  • LinkedIn
  • Pinterest
  • RSS
  • Twitter
  • Websites
  • FAQs
  • Tips & Tricks
    • Apple
      • iPad & Apps
      • iPhone
    • CMS
      • WordPress.org
    • Microsoft Office
      • Excel
      • Outlook
      • Word
    • Miscellaneous
      • Browser
      • Email
      • Kindle
      • Skype
    • Social Media
      • Facebook
      • Google+
      • Twitter
    • Windows

Customise Excel’s Default Workbook 2010

December 5, 2012 Lins

If you really only use one sheet and not the default three that Excel creates with any new workbook you can customise this to suit your way of working. Change Excel’s default settings by going to the File menu > Options > General.  Look in the section ‘When creating new workbooks’ and change ‘Include this […]

Excel, Microsoft Office, Tips & Tricks

Recovering unsaved workbooks – Excel 2010

October 29, 2012 Lins

Mistakenly closed a workbook without saving? You can sometimes recover your work in Excel 2010. Go to File, Info, click the Manage Versions button and select Recover Unsaved Workbooks. Excel 2010 automatically keeps a copy of many (but not all) unsaved workbooks for a few days.

Excel, Microsoft Office, Tips & Tricks

Excel Spell Check

October 18, 2012 Lins

Spell check all worksheets in an Excel file. Right-click on one of the worksheet tabs. This will open a quick menu from which you can choose ‘Select All Sheets’. Press the function key F7 to begin the spell check.

Excel, Microsoft Office, Tips & Tricks

Highlight All Cells Referenced by a Formula

October 3, 2012 Lins

Excel 2010. To highlight all the cells referenced by a formula press Ctrl+[ (that’s Ctrl and open-square-bracket). The current selection will also move to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell, continue to press Enter to move though the rest of the referenced cells.

Excel, Microsoft Office, Tips & Tricks

Custom format a telephone number

September 19, 2012 Lins

Want to format a phone number? Use Ctrl+1 to bring up the Format Cells dialog box. In the Type: text box enter (+00) 000 000 0000 for 2 digit country codes.

Excel, Microsoft Office, Tips & Tricks

Quickly Sum Non-Contiguous Cells

September 10, 2012 Lins

Click the AutoSum button. Then, one at a time, click each of the cells you want to sum, typing a comma to separate each cell in the formula (e.g. =SUM(C8,D10,F8,H8,J8). Another option is to hold down the CTRL key (instead of typing the comma) as you are selecting the cells. You can also drag to […]

Excel, Microsoft Office, Tips & Tricks

Quick Navigation

September 6, 2012 Lins

When you press the Ctrl key combined with any arrow key (north, east, south, or west), you jump to the last populated cell in that direction.

Excel, Microsoft Office, Tips & Tricks

Repeat Action

August 29, 2012 Lins

To repeat the last action that you’ve just taken, select a cell or a range of cells where you want to repeat it and press the function key – F4.  You can repeat this over and over.

Excel, Microsoft Office, Tips & Tricks

Today’s Date

August 24, 2012 Lins

To insert Today’s date use Ctrl+; (semicolon) on the keyboard.

Excel, Microsoft Office, Tips & Tricks

Cell Navigation

August 23, 2012 Lins

To move through a group of cells that you’re working on (without going outside the range) highlight the group of cells and then use the “Enter” key to move through them.

Excel, Microsoft Office, Tips & Tricks

  • « Previous Page
  • 1
  • 2
  • 3
  • Next Page »

Chat

Click the Chat button to get in touch with us now. Chat Icon

Our Details

Registered Office:
Booth House
Llysyfran
Pembrokeshire, SA63 4RS

01437 532 813
Email LJC

Policies & Info

  • Privacy Policy
  • Cookie Policy
  • Website Terms & Conditions
  • Terms & Conditions
  • Hosting Comparisons
  • FAQs
  • Contact Us

Latest WordPress Tip

Automatic background updates were introduced in WordPress 3.7. An email notification is sent (subject line below) following the success or failure of the update. Subject: [Your … [Read More...]

More Posts from this Category

Copyright © 2022 · LJC on Genesis Framework · WordPress · Log in

We use cookies to ensure that we give you the best experience on our website. By clicking “Accept All”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent. Read More
COOKIE SETTINGS ACCEPT ALL
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
CookieDurationDescription
bcookie2 yearsThis cookie is set by linkedIn. The purpose of the cookie is to enable LinkedIn functionalities on the page.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
CookieDurationDescription
_gat1 minuteThis cookies is installed by Google Universal Analytics to throttle the request rate to limit the colllection of data on high traffic sites.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
_ga2 yearsThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assign a randomly generated number to identify unique visitors.
_gid1 dayThis cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
bscookie2 yearsThis cookie is a browser ID cookie set by Linked share Buttons and ad tags.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
cookielawinfo-checkbox-functional1 yearThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-others1 yearNo description
li_gc2 yearsNo description
SAVE & ACCEPT
Powered by CookieYes Logo