EXCEL – Copying Row Height or Width
Have you ever wonder if there is an easy way of copying a row height?
There is a very easy way to do this as follows:
- Highlight the row you want to copy.
- Click the Format Painter button, found on the Standard toolbar in Excel 2003 or earlier (and on the Home tab of the ribbon in Excel 2007)
- Click on the row number that you want to paste the row height to and voila – you have copied and pasted your row height.
Till next time.
wizTEQ Staff
Microsoft Excel Blog: Chart templates
Help and How-to for Microsoft Office Excel 2007
This blog post clarifies the importance of a chart template, why it is useful, and how to create one.
How to remove hyperlinks in Excel
One of the things that Microsoft did in pursuing “Internet enabled applications” was to force, beginning with Excel 2000, the program to recognize URLs and e-mail addresses as something special. When you input one of these, Excel automatically formats it as an active hyperlink, and may even start some other program, such as your e-mail client or a browser.
Replace a word or phrase in a spreadsheet
You’re probably familiar with the search and replace feature in your word processing application. This feature finds every instance of a particular word or phrase and replaces it with another word or phrase. Excel can also support this feature. If you misspell a name or need to update a frequently used reference, use Search and Replace.
A very cool use of Paste Special
Have you ever been working in Excel and wanted to increase the value of a range of cells by say, 20%? This can mean typing in the new values, or it can be done with a hidden column and formulas, or by making the cells all formula-based to start with when you create the worksheet.
Adding, renaming or deleting worksheets
When an Excel Workbook is created, it normally defaults to three worksheets. Worksheets can be added, renamed, or deleted. Read more
Excel’s Hidden Menu Options
Did you know that there are really two different menus in the Excel menu system? Sounds pretty odd, but try this. Read more
Helpful tips for Excel
Here are a few Excel tricks to keep up your sleeve.
Need a super easy way to copy an entire worksheet? Here’s all you need to do.
Select the tab of that worksheet. Next, hold down the Ctrl key and, using your mouse, drag the tab of that worksheet either to the left or the right. You’ll see what looks like a little sheet of paper with a plus sign on it (If you don’t see the plus sign, make sure you are holding down Ctrl). Drag that little sheet wherever you wish to copy it, let go of the mouse, and there it is.
Making a Complicated Spreadsheet Easier to Read
If reading an Excel spreadsheet leaves you feeling cross-eyed, there are simple steps you can take to make the information easier to handle. This tip shows how to delineate the data by changing the gridlines and columns.