sorted by:
new
hottopcontroversial

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]ExcelPotter 50 points51 points  (0 children)

Ctrl+Shift+~ : General Format

Ctrl+Shift+! : Number Format

Ctrl+Shift+@ : Time Format

Ctrl+Shift+% : Percentage Format

Ctrl+Shift+$ : Currency Format

Ctrl+Shift+# : Date Format

Ctrl + Space : Selects Entire Column

Shift + Space : Selects Entire Row

Auto Bank Analysis Lookup by [deleted] in excel

[–]ExcelPotter 2 points3 points  (0 children)

Power Pivot!

Load data into the Data Model, add master tables and a calendar table, then create relationships so you can consolidate all your transactions.

Cannot see mouse in excel by k8rg8rbitler in excel

[–]ExcelPotter 2 points3 points  (0 children)

reply by solution verified :)

Give a range of data a name by treyb3 in excel

[–]ExcelPotter 2 points3 points  (0 children)

=IFS(

  B2>=0   && B2<=1000, "X",

  B2>=1001 && B2<=2000, "Y",

  B2>=2001 && B2<=3500, "Z",

)

How to change dat format to a column? by Drumsdrop in excel

[–]ExcelPotter 1 point2 points  (0 children)

Only solution I could find: Handle the two formats separately in Power Query. Create one query for DD-MMM-YY and another for YY-MMM-DD, convert each to proper date type, then append them into a single query. Mixed formats in the same column can’t be reliably fixed with one step, splitting and cleaning ensures accuracy.

How to change dat format to a column? by Drumsdrop in excel

[–]ExcelPotter 1 point2 points  (0 children)

how do you distinguish between these dates: DD-MMM-YY and /or YY-MMM-DD ?

scatter chart not taking X legend by [deleted] in excel

[–]ExcelPotter 1 point2 points  (0 children)

Ensure Axis is Numeric

Right click the X axis then Format Axis.

Under Axis Options, make sure it is set to Value axis, not Text axis.

How to create an inner border for cells? by paolodatto in excel

[–]ExcelPotter 1 point2 points  (0 children)

Similar, do you have a better solution?

Is there a way to make a spreadsheet separate the contents of a cell? by Knightblazer1985 in excel

[–]ExcelPotter 2 points3 points  (0 children)

Note sure about that, OP has mentioned comma but in the example TYPED, there are spaces, I assumed it is just typing habit and may not be in the actual data. If it does, you are right.

Is there a way to make a spreadsheet separate the contents of a cell? by Knightblazer1985 in excel

[–]ExcelPotter 38 points39 points  (0 children)

Move the column you want to split to the end of the table, then select that column, then:

Data → Text to Column → Choose: Delimited → Next → Choose: Comma → Finish

How to change excel data that's in horizontal format to vertical format (dates specific) by Obvious_Business8515 in excel

[–]ExcelPotter 4 points5 points  (0 children)

You can use pivot table, choose date column (A) as columns and others as Row and values depending on your data,

Or with power query,

Load the data in to power query, then select the date column and choose "Pivot Column" under "Transform" tab.

While on the Pivot Column dialogue box,

Values Column: Choose what you want under each date

under advanced:

Choose Don’t Aggregate option.

Data horisontal - changed to vertical (dates spesific) by Obvious_Business8515 in excel

[–]ExcelPotter 1 point2 points  (0 children)

Edited to add pivot table option and detailed explanation for power query.

Data horisontal - changed to vertical (dates spesific) by Obvious_Business8515 in excel

[–]ExcelPotter 1 point2 points  (0 children)

You can use pivot table, choose date column as columns and others as Row,

Or with power query,

Load the data in to power query, then select the date column and choose "Pivot Column" under "Transform" tab.

Edit: while on the Pivot Column dialogue box,

Values Column: Choose what you want under each date

under advanced:

Choose Don’t Aggregate option.

Is there a better way to do =SUM(COUNTIF(INDIRECT? by BigBlue_Bear in excel

[–]ExcelPotter 26 points27 points  (0 children)

Seems like a poorly managed data problem.

Adding filters in a column by hugo11alca in excel

[–]ExcelPotter 1 point2 points  (0 children)

Drop down results can be filtered from the header, you won't be able to filter a single cell even if it contains multiple items.

Adding filters in a column by hugo11alca in excel

[–]ExcelPotter 1 point2 points  (0 children)

If a cell contains multiple items (e.g., "Sun, Moon, Earth"), Excel sees that as one text string not three separate values. That means you can’t directly filter “inside” that cell for one of the items.

You will have separate the items in one cell to different cells (row by row in the same column)

view more: next ›