Excel Q&A Forum

Microsoft Excel Question & Answer Forum.

Ask Question
View All Possible Tags
+
Pivot Table Amount in Lacs
excelformattingpivottable
asked: Jun 29, '18 at 6:07 am | by: suddushetty (rep: 2)
Answer Selected Answers: 2
Data Validation for Today's Date
exceldata-validationformattinguser-defined-functions-udf
asked: Jun 27, '18 at 11:31 pm | by: Sroncey21 (rep: 10)
Answer Selected Answers: 1
How to remove the leading numbers and period (prefix only in a string without effecting other numbers in the data ?
excelformulas-functionsconsolidate-dataformattingtext-manipulation
asked: Jun 7, '18 at 11:07 pm | by: aceventura2
Answers: 1
How to get variables linked to a dollar amount and then added to a different colum
excelformulas-functionsfinanceformattingtext-manipulation
asked: Jun 7, '18 at 12:07 pm | by: ashbigs (rep: 2)
Answer Selected Answers: 1
Using a Macro to generate code for color when conditional formatting is already in use.
excelmacros-vbaformatting
asked: May 30, '18 at 6:22 pm | by: cagee0215 (rep: 2)
Answers: 2 | Votes: 1
How to format a number to my desired outcome?
excelformatting
asked: Feb 23, '18 at 1:07 am | by: jon_yao
Answers: 1
How to produce "thermometer-like" graphic in Excel (see illustration)
excelchartsformatting
asked: Jan 19, '18 at 9:30 am | by: Uh Clem (rep: 2)
Answers: 0
Sorting Data into specific cells automatically
excelformatting
asked: Dec 5, '17 at 7:48 am | by: PNS
Answers: 0
Date and time format changing
exceldate-timeformattingimport-export
asked: Nov 1, '17 at 5:39 pm | by: Mim
Answers: 1
VBA to adjust size of existing footers
excelmacros-vbaformattingheader-footer
asked: Oct 30, '17 at 9:46 am | by: lvansan411
Answers: 1
Conditional formatting based on dates in other columns
excelformulas-functionsformatting
asked: Oct 16, '17 at 12:49 pm | by: Ivory Tickler
Answers: 1
Copy Worksheets and Keep All Formatting - Including Print Formatting
excelformattingprinting
asked: Sep 28, '17 at 6:04 pm | by: Barb (rep: 2)
Answer Selected Answers: 2
Aligning decimals with varying decimal places
excelformatting
asked: Sep 20, '17 at 12:05 pm | by: begreen12 (rep: 2)
Answer Selected Answers: 1
I need help with formulas and formatting to create a complex employee schedule maker layout
excelformulas-functionsformattingworksheet-settings
asked: Sep 15, '17 at 6:58 am | by: KEBinAZ (rep: 4)
Answer Selected Answers: 1
Error value present in cell causing formulas to be negated.
excelformulas-functionsformatting
asked: Sep 13, '17 at 10:33 pm | by: KEBinAZ (rep: 4)
Answer Selected Answers: 1
How do I create a live copy of a worksheet in a secondary workbook
excelformattingworkbook-settings
asked: Sep 11, '17 at 2:08 pm | by: Carrie
Answers: 2
Can no longer format currency in cell
excelformatting
asked: Sep 5, '17 at 12:16 pm | by: Teapot (rep: 2)
Answer Selected Answers: 1
VLookup and Dates formats help need!
excelmacros-vbavlookupdate-timeformatting
asked: Aug 21, '17 at 12:28 pm | by: Jonacz (rep: 4)
Answer Selected Answers: 1
Saving formatted columns
excelcsvformattingtext-manipulation
asked: Aug 3, '17 at 1:31 pm | by: Lgsalem
Answers: 1
Preserving Chart Formatting when refreshing Data in Powerpivot Workbook
excelmacros-vbachartsformatting
asked: Jul 24, '17 at 3:43 pm | by: jengla01
Answers: 1
how do i split formulated value in a cell once it has reached a maximun lenght
excelformulas-functionsformatting
asked: Jun 21, '17 at 7:55 pm | by: gleno767
Answers: 1
How to Create a Tornado (Butterfly) Chart to Display Stacked Bars
excelmacros-vbachartsformatting
asked: Jun 19, '17 at 6:26 am | by: Simon
Answers: 1
Data Validation and Conditional Formatting Question
exceldata-validationformatting
asked: May 25, '17 at 11:31 am | by: wwsydb (rep: 4)
Answer Selected Answers: 1
Subtracting a varied break times on a time sheet.
excelformatting
asked: May 22, '17 at 4:07 am | by: debrahilton
Answers: 1
Date converting
exceldate-timeformatting
asked: Apr 20, '17 at 10:07 am | by: petere (rep: 2)
Answers: 1 | Votes: 1
How to insert images with pop up
excelformatting
asked: Apr 12, '17 at 10:00 am | by: Cafu
Answers: 1
Add a leading zero to all cells that contain a colon
excelformulas-functionsdate-timeformatting
asked: Apr 14, '17 at 4:54 pm | by: Harrison (rep: 2)
Answer Selected Answers: 1
import large numbers from csv file
excelformattingimport-export
asked: Apr 9, '17 at 12:39 pm | by: sammyB (rep: 4)
Answer Selected Answers: 1 | Votes: 1
Purchase order
excelformulas-functionsadd-insdata-validationformatting
asked: Mar 24, '17 at 11:48 pm | by: phoneguy (rep: 8)
Answer Selected Answers: 1
Inventory Reorder formula (conditional formatting)
excelformulas-functionsdata-analysisdata-validationformatting
asked: Mar 23, '17 at 7:42 pm | by: phoneguy (rep: 8)
Answer Selected Answers: 1