You are here:

Microsoft Software

Recent Answers

2017-01-19 Excel - Secondary drop down lists:

Bill,    If I was going to give you an answer, it would be the one you describe.     This approach is documented at Debra Dalgleish's site      http://www.contextures.com/tiptech.html    go to data validation

2017-01-19 Excel - Excel - Print 1 copy different:

Martin Cadwallader,    If you want all the copies to be identical except one copy to have additional information in one of the cells, you would need to print out twice.  One with 10 copies and no additional

2017-01-17 Excel - Copying CSV file into Excel sheet:

RICHARD    To copy the entire sheet instead of painting the cells you want to copy, and then copying them,  Just click on the box at the intersection of row 1 and column  A and then perform the copy paste

2017-01-16 Excel - absolute references in structured references:

Bill,    As a test    =Database[[#Headers][Type]]  remained the same if I copied and pasted it to cells to the right  (or selected the cell for the formula and multiple cells to the right, entered the

2017-01-16 Excel - blank cells vba:

Dave,    If the cells are actually blank then     Range("A1:N50").specialcells(xlBlanks).Value = "X"    this is equivalent to selecting A1:N50, then hitting F5 to get the goto dialog, selecting special

Categories

Browse Alphabetically

©2017 About.com. All rights reserved.