- Subscribe to this page:
- RSS
- Email Alert
column
(178 results)-
Discussion Threads
Build a simple timesheet in Excel
May 3, 2013 1:40am PDT
Build a simple timesheet in Excel article root A Couple of Ideas I like your step by steps, the following are things I usually do to make it easier on both the developer and the user. When...
-
Discussion Threads
Three ways to guide users through an Excel input range
March 8, 2013 4:54am PST
Three ways to guide users through an Excel input range article root Table and Protection Hello Susan, As always your tips are valuable. Concerning to this topic I have a question that I hope you...
3 Started by McGnity | Latest comment by Marshwiggle
-
Discussion Threads
How to find duplicates in Excel
March 6, 2013 7:34am PST
How to find duplicates in Excel article root Excel 2007 and later, use conditional formatting In Excel versions 2007 and later, it is much easier to find duplicates using Conditional,...
8 Started by eclark@... | Latest comment by thanhonap
-
Discussion Threads
10 steps to creating a custom list for sorting in Excel
February 7, 2013 7:55am PST
10 steps to creating a custom list for sorting in Excel article root Custom Sort Great tip, Susan! This came at an opportune moment for me, and simplified what initially was starting to look...
5 Started by DaveUnger | Latest comment by ssharkins@...
-
Discussion Threads
An easy technique for creating a floating column chart in Excel
November 27, 2012 11:31pm PST
An easy technique for creating a floating column chart in Excel article root Excellent Tip Hello, Excellent article. The best part was adding the °F sign in the Axis. ppriciate your efforts in...
11 Started by adgarg@... | Latest comment by gobrannan@...
-
-
Discussion Threads
Using Excel's Text To Columns feature to clean up foreign data
November 21, 2012 7:39am PST
Using Excel's Text To Columns feature to clean up foreign data article root Thanks for pointing out this Excel feature! I have not previously used this feature, although I use "Table to Text"...
11 Started by mslizny | Latest comment by ssharkins@...
-
Discussion Threads
Excel lost column labels
October 7, 2012 12:25pm PDT
Excel lost column labels How do I restore my column lables "A" "B" "C"... back on my excel spreadsheet. I have the row lables "1", "2", "3"... but know lables.
1 Started by dickatkins | Latest comment by dickatkins
-
Discussion Threads
How to list the primary key columns in an Access table
September 10, 2012 9:00am PDT
How to list the primary key columns in an Access table article root Object or provider is not capable of performing requested operation Hello Susan, I am trying this out with an Access database...
-
Discussion Threads
10 steps to a multi-column search in Excel
July 6, 2012 6:18am PDT
10 steps to a multi-column search in Excel article root Off-screen rows I'm not sure there would be a lot of times when I would want to use this approach over auto-filter or database lookups....
1 Started by sparent |
-
Discussion Threads
Take advantage of Google mail search tools both powerful and simple
June 25, 2012 3:38pm PDT
Take advantage of Google mail search tools both powerful and simple article root Mayor flaw on search Google cant search regular expressions. ej search "Angels" is not the same "An*" You need to...
2 Started by julioa.morales@... | Latest comment by michaellashinsky@...
-
Discussion Threads
Office challenge: Can you avoid re-entering integer values that are supposed to be percentages?
April 19, 2012 2:07am PDT
Office challenge: Can you avoid re-entering integer values that are supposed to be percentages? article root Paste Special does it Add a column to the right of the incorrectly formatted data,...
3 Started by allan.pettie@... | Latest comment by v_balaj@...
-
Discussion Threads
A quick and dirty way to compare columns of Excel data
April 6, 2012 8:55pm PDT
A quick and dirty way to compare columns of Excel data article root Nice Handy tip. :) Very Useful Tip Thanks for posting this... What version of Excel? Unfortunately, some of us are still...
25 Started by lehnerus2000 | Latest comment by HAL 9000
-
Discussion Threads
Office challenge: Why is Excel displaying a date instead of a numeric value?
April 5, 2012 8:45am PDT
Office challenge: Why is Excel displaying a date instead of a numeric value? article root Cell Formatted in date format Change to general or number.. Option is mis-picked Under (2010) File...
16 Started by jamesski | Latest comment by Marshwiggle
-
Discussion Threads
CSS3 styling for data tables
February 29, 2012 8:55am PST
CSS3 styling for data tables article root Oops! I referenced some html5 tags in angled brackets & they disappeared... [Quote marks this time...] According to the validator.w3.org it appears the...
2 Started by jeffrey.bollman@... | Latest comment by jeffrey.bollman@...
-
Discussion Threads
Office challenge: How would you sum every other value in a column?
February 17, 2012 12:18pm PST
Office challenge: How would you sum every other value in a column? article root SUMPRODUCT(MOD(ROW())) is one answer The formula =MOD(B1,2) would return 0 if the number is even and 1 if it's odd,...
11 Started by Darryl~ | Latest comment by sk.tomar@...
-
Discussion Threads
Office solution: How to continue numbering from one table column to another
January 31, 2012 8:42am PST
Office solution: How to continue numbering from one table column to another article root Numbering columns Hi Susan Can you explain what was wrong with my solution, please...
3 Started by michael_boardman@... | Latest comment by sheila@...
-
Discussion Threads
Why doesn't somebody re-market these?
January 26, 2012 9:18am PST
Why doesn't somebody re-market these? I used to love these screensavers. It seems like if someone picked up the code from the company that bought After Dark and re-engineered them for today's...
-
Discussion Threads
Office challenge: Can you continue numbering by column?
January 18, 2012 2:53pm PST
Office challenge: Can you continue numbering by column? article root Continue numbering by column... ...can be done by creating literal columns in the document and connecting the single column...
7 Started by Rick Caringer | Latest comment by smileyface522
-
Discussion Threads
A quick way to delete blank rows in Excel
January 6, 2012 6:13am PST
A quick way to delete blank rows in Excel article root this doesn't look like a Good Thing to me only going to work if you can guarantee that there are no other blank cells and that all the...
3 Started by jbenton@... | Latest comment by jbenton@...
-
Discussion Threads
Office solution: Keyboard shortcuts for hiding and unhiding columns and rows
January 5, 2012 7:38am PST
Office solution: Keyboard shortcuts for hiding and unhiding columns and rows article root [Ctrl]+[Shift]+0 shortcut not working in 2010 for me All the others work, but in Excel 2010...
7 Started by gitmo | Latest comment by ahmed19imran@...
