Excel - Freezing Panes
When working on a large spreadsheet you have most likely run into this problem, you scroll down or over to the right and you lose sight of your column headers and row titles. But don’t fret Excel has a simple solution.
Excel gives you the ability to freeze the view of your worksheet so you can always see what you want – where ever you are on the sheet. Freezing panes lets you keep specific rows or columns visible when you scroll.
To Freeze panes choose View from the menu and the View Ribbon will appear. From there click the down arrow to the right of the Freeze panes button with your cursor placed in the worksheet as described below:
- To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
- To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.
- To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll. (In the example below the cell that is outlined in red is where your cursor should be placed to lock both rows and columns).
Once you have frozen the panes you will see a dark line below and to the right of the rows and columns you selected – these delineate the frozen panes.
To unfreeze panes go to View from the Menu and click the arrow next to Freeze Panes and choose Unfreeze.
Notes: you can still edit within the frozen panes. Simply click on a cell within the frozen panes and do your edit. Then click on a cell outside of the frozen panes to again to continue to work on your spreadsheet. These options are not available when a worksheet is protected.
If you need help working with an MS office project contact me at firstname.lastname@example.org I have years of experience and can help you.
What is a Premium Domain Name?
A few weeks ago I was looking for a domain name for a project and discovered that the .com we wanted was available. When I went to register it, the cost was almost a $1,000! I was shocked and began to do some research to understand what constitutes a domain name being premium. Here’s the results…
A premium domain name is not always one that someone is trying to sell for a profit, but can also be based on the value of the characters or words in the domain. Here are four criteria that can make it a premium name.
1. Perceived Value – This is the value that people place on the domain that they believe can be sold for a large profit. This perceived value does not necessarily mean that’s what it’s truly worth. A rule of thumb is if the domain is selling for more than $1,000 it’s a premium.
2. Memorable – Easy to spell, short, brandable, and simple to pronounce. The more memorable the domain name is the more dollars it is worth. Another criteria is if there is no other variations in its spelling.
3. Generic – Words and combination of words that are exact matches to generic key words used most often by people searching the web (such as symptomhelp.com or petfood.com.)
4. Commercial or Industry Intent – The closer a word is to a commercial product or an industry the more valuable it becomes. So, for example if you choose “medical” as part of your domain name vs. bird you will be paying more for the use of “medical”.
So next time you look into registering a domain name, don’t be surprised if you find at least one domain name that will cost a premium to purchase.
If you need help registering a domain name or getting started on the web site contact me at email@example.com, I have been working with web clients for over 17 years!
You Have To Laugh
Turkey and dog play soccer? http://www.cnn.com/video/data/2.0/video/offbeat/2014/07/06/orig-distraction-turtle-dog-soccer.valeria-dinnocenzo.html