Do you download data into your spreadsheet? #Excel #WorkSmarter #WorkFaster #ShortCut
What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut
A shortcut can run a macro to manipulate your data #Excel #WorkSmarter #WorkFaster #ShortCut
What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut
A shortcut could set your printing options. #Excel #WorkSmarter #WorkFaster #ShortCut
A shortcut could insert formulas, symbols or apply formatting. #Excel #WorkSmarter #WorkFaster #ShortCut
What will you do with this shortcut key? #Excel #WorkSmarter #WorkFaster #ShortCut
If you work on a laptop, entering symbols with the numeric keypad might not be available. Having a macro to insert your symbol can be a timesaver! #Excel #WorkSmarter #WorkFaster #ShortCut
Excel doesn't have a toggle case shortcut - so I wrote one!
Sub ToggleCase()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
If Rng.Value = StrConv(Rng.Value, vbProperCase) Then
Rng.Value = StrConv(Rng.Value, vbLowerCase)
ElseIf Rng.Value = StrConv(Rng.Value, vbLowerCase) Then
Rng.Value = StrConv(Rng.Value, vbUpperCase)
ElseIf Rng.Value = StrConv(Rng.Value, vbUpperCase) Then
Rng.Value = StrConv(Rng.Value, vbProperCase)
End If
End If
Next Rng
End Sub
#Excel #WorkSmarter #WorkFaster #ShortCut
This is a Facebook demo page created by plugin automatically. Please do not delete to make the plugin work properly.
[my-instagram-feed user_id=”17841406885088305″ feeds_per_page=”2″ caption_words=”50″ cache_unit=”5″ cache_duration=”days”]