2011-03
How to Create A Linkable Hot Image
You might have noticed that some Web sites feature an hot image map to help navigate the site. An image map is a single image, but it’s sensitive to the location at which you click it on hot area. This tip demonstrates how to create a linkable hot image.
How To Highlight Entire Current Row And Column In Excel
How can I use VBA or conditional formatting to highlight the entire current row and column of the current cell?
In your sheets worksheets selection change event, you can use something like this:
Getting Coefficients Of Chart Trendline
When you add a trendline to a chart, Excel provides an option to display the trendline equation in the chart. This article describes how to create formulas that generate the trendline coefficients. You can then use these formulas to calculate predicted y values for give values of x.
How To Create A Splash Screen For An Excel Workbook
This article describes how to create a splash screen for a Excel workbook. A splash screen appears when the workbook is opened and disappears automatically after a specific time has elapsed.
Setting it up
Follow these instructions to create a splash screen for your project.
Using COUNTIF function to compare two columns in Excel
I have an excel document with columns A and B. Row A has 2595 values. Row B has 411 values.
I’m trying to figure out how I can compare these two columns by marking column C with the number of times we find a value(s) from column A.
Use keyboard shortcut to Zoom in or out on Excel Workbook
For most purposes, Excel allows you to issue commands and perform functions by using either the mouse or the keyboard. Unfortunately, Excel does not provide “equal access” for all commands. For instance, it is relatively easy to zoom in or out using the mouse, but there is no easy way to do it using the keyboard (other than using the keyboard to traverse the menus and select a zoom setting).
Choose the best type of chart in Excel
One factor to consider as you want to choose the best type of chart in Excel is the relative strengths and weaknesses of each type of graph. One could, of course, write an entire book on this subject. However, May you find it useful to examine the strengths and weaknesses described in the paragraphs that follow to choose a graphic.
How to set default zoom size for specific Workbooks when opened
If you work with workbooks first worked on by your colleagues, you may be frustrated by the zoom factor applied to those workbooks by those others. For instance, if your colleague (Wanda) has a huge monitor, it wouldn’t be uncommon for her to reduce the zoom factor on Excel to 75% or even 60%. The purpose, of course, is so she isn’t overpowered by things that look very large at the full zoom factor.