If a table is made up of formulas, paste transpose with mess up the formulas, but there is a way around this.
Category: Excel
Get the day of the week from a date in excel.
dddd = weekday
In this example, I have two datasets with different dates, and I want to line them up, using a formula, with the closest date, either before or afterwards.
Plot latitude and longitude coordinates on a bubble chart in excel, and change the background of the chart to an image of a map.
Microsoft Excel has a feature for making 3D maps using Bing, but you can also use this to make 2D maps.
Excel doesn’t have a feature for adding subscripts and superscripts into legends in excel charts but there is a way around this using symbols.
How to apply number formatting to cells using shortcut keys in excel
In Power Query the columns will automatically line up so long as they have the same column headings.
How to make the bubbles in a bubble chart different colors based on there values, and make it appear as if the chart has conditional formatting, by using an IF formula and making multiple different series.
Quickly copy the formatting from one chart to another in excel and save the formatting to use later.