A client wants to know how to insert checkmarks into a spreadsheet for printing only.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Check out this podcast entered into competition at: www.alphageekchallenge.com ! Click the "Vote Now" tab to view the contest entry.
Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel Episode 1169.
Create 2009 Actual vs 2010 Budget in a pivot table.
Using PowerPivot for Excel 2010 to create asymmetric pivot tables.
Sort data where each record occupies three rows.
Erik asks how do deal with data where each record takes up three rows. Episode #1176 shows you how.
Use countif for variable value.
A question from Trinidad about using countif. Episode #1175 shows you how.
Links stop updating in Excel 2007.
A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode #1174 shows why and how to fix this problem forever.
Move a column of names to be a row of names.
Paula asks how to take a range and turn it on its side. Episode #1173 shows you how.
Pivot tables start appearing in strange sequences in Excel 2007.
Szilvia noted a strange anomaly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode #1170 takes a look at this mystery and the solution.
