Use this tip to freely convert any of your Word or Excel files to a PDF document. Continue reading
Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!
Shop online 24hrs a day or call us Mon-Fri
9AM-5PM EST - 1-800-915-2088
Newsletter On The Internet!
Shop online 24hrs a day or call us Mon-Fri
9AM-5PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Posts Tagged ‘excel’
How Do I Convert Word Files To PDF Documents?
Tuesday, December 11th, 2012Protect Individual Cells from Being Edited in Excel 2007
Monday, April 23rd, 2012Ever wonder how to make individual cells locked so you don’t mistakenly edit formulas in Excel? Read this tip to find out the easy way how! Continue reading
Alphabetizing in Open Office
Tuesday, November 15th, 2011George from Trinidad asks: “Is there a way to put a list of items in alphabetical order in Open Office?”, and gets and answer! Continue reading
MS Office: Calculating Time Difference in Excel
Sunday, September 11th, 2011It is possible to calculate time totals in Excel. Here’s a quick tutorial to show you how! Continue reading
How to Password Protect Worksheets in Excel
Tuesday, April 19th, 2011MS Excel: A Locked Cell is Not a Cell Protected From Changes
If you’ve ever found yourself nosing around the Protection tab in the Format Cells dialog box then you’ve probably found that the Locked check-box was selected and possibly thought that your worksheet was safe from changes made by others…
MS Excel: Customizing Worksheet Defaults
Thursday, April 7th, 2011There are certain things that we’d all like to have when we begin a new Excel workbook… such as number of worksheets, font, font size, etc…
For many people, this seems like an elusive process, since there are so many places to investigate looking for the old Default button.
Fortunately for all of us, a few
Finding Tabs in Spreadsheets
Friday, March 18th, 2011Richard from San Antonio asks:
I create a large number of tabs in Excel 2007 spreadsheets, each with a distinct title. Is there a way to search for a specific tab within the spreadsheet? Some of the spreadsheets might have 100 or more tabs.
Thanks for the question
Using a Spreadsheet within a Word Document
Friday, March 18th, 2011MS Word: Using a Spreadsheet Within a Document
On more than one occasion, I’ve found that within a document I’ve needed to present data that really should be set up in Excel.
Don’t get me wrong, Word’s tables are great, but when it comes to calculations and numeric data displays, Excel wins hands down.
Paste with the Enter Key in Excel
Thursday, March 17th, 2011If you’re anything like me, you believe that there’s only one option when using the keyboard to paste in MS Excel – Ctrl+V.
While that obviously will paste your copied or cut information as it always has, you do have another option if you’re only looking to paste in one location.
MS Excel: Format Cells Dialog Box
Thursday, March 10th, 2011MS Excel: Finding a Long Lost Friend… the Format Cells Dialog Box
Let’s be honest, there are times when faced with the Ribbon and all its tabs, groups and buttons, that we miss our old friend the Format Cells dialog box.
It was our “one-stop”
MS Excel: Creating Visual Breaks Without Using Cell Borders
Friday, February 18th, 2011When setting up a worksheet where we need to separate one section of information from another, and present that separation clearly, we often use cell borders to accomplish the job.
Obviously that option is a great way to get the job done, but we tend to use those for everything… so making that visual break between data sections requires a bit of finesse with those borders.
Copy and Paste Only a Cell Comment in MS Excel
Thursday, February 17th, 2011MS Excel: Copy / Paste Only a Cell Comment
When reviewing the contents of a worksheet, do you find that you’ve got the same comment to make over and over again? (The least of which being “Where the heck did that come from?”)
I know that when I go through and start getting into
Creating Macros in MS Excel
Wednesday, February 9th, 2011Microsoft Excel is the one of the most popular spreadsheet programs used worldwide. It has a variety of features such as data storage, creating reports and charts, using mathematical functions, performing statistical analysis, ability to connect to databases, making use of pivot tables, V-lookups etc. One such very useful feature within Microsoft Excel is the ability to make use of “macros”.
What is a Macro?
Deleting Multiple Comments in Excel
Thursday, February 3rd, 2011MS Excel: Delete Multiple Comments at Once
If you’ve got an Excel worksheet that contains a lot of comments, it can be a bit of a pain to remove them all when you’re done.
Think about it. If the worksheet is a large one and you’ve managed to accumulate quite a few comments, it’s
Applying Options in MS Office
Thursday, January 20th, 2011When you’re in the Options dialog box for one of these newest MS Office programs, have you ever noticed this part of a section header? (You’ll notice that not all section headers have one…)
Even if you did notice it…did you take the time to investigate?
For many people the answers are no…
Resetting the Default View in Excel
Tuesday, January 18th, 2011MS Excel 2007 & 2010: How Do You Like to View It?
We all have one… you
know, that preferred view of our MS Excel worksheets.
Some people like to see
everything in the Normal view.
Others prefer the Page
Layout view, where Excel shows the physical breaks between each page, as well
as the… Continue reading
Shrink to Fit in Excel
Friday, January 14th, 2011MS Excel: Data Too Long
for the Cell? Use Shrink to Fit & Let Excel Fix the Problem for You!
Ever have data in MS Excel that’s just a bit too long for the cell?
What happened?
Did the column widen to accommodate? Or, maybe you got the infamous
Using the Clipboard in MS Office
Tuesday, January 11th, 2011MS Office 2007 & 2010: I Thought That the Clipboard Could Hold More Than One Item?
You’re right – it can…
you were used to accessing something like this via the Edit menu in older
versions of MS Office:
A clipboard pane where all
the items that have been copied or cut, are stacked in a list… Continue reading
