User Profile

BlairHall

Copper Contributor

Joined Dec 19, 2020

4 Posts2 Solutions

View All Badges

User Widgets

Recent Discussions

Re: using named ranges
This happens when your zoom percentage is below 40%. Try zooming in to 40% or higher - it should automatically disappear.
Jun 12, 2021 Place Excel
2.1KViews
0likes
1Comment
Re: Raccourcis Excel pour trier une colonne par ordre décroissant
You can do this two ways. 1 - Alt-D, S, then tab multiple times until you get to the order field, and press "L" or down arrow to change that sort order, then press enter 2 - Alt, H, S, O
May 22, 2021 Place Excel
3.2KViews
0likes
0Comments
Re: Semicolon cel to rows conversion
This is pretty straightforward using Power Query: Click inside one of the cells in your "(old)" range. Go to Data, From Table/Range, confirm the range, and check the "My table has headers" checkbox. Ok. The Power Query editor will open. Click on the header for the second column "Y(old)". Go to the menu item, Home → Split Column → by Delimeter. Ensure the delimter is "Semicolon", "Each occurrence of the delimiter", expand the "Advanced Options", and choose to split into Rows. Click Ok. Then go to Home → Close & Load. A new worksheet will be created with your reformatted data.
May 22, 2021 Place Excel
10KViews
0likes
1Comment

Recent Blog Articles

No content to show