Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
home_server:mswindows_notes [2025-03-18 Tue wk12 16:55] – [MS Excel Highlight Row or Column] baumkphome_server:mswindows_notes [2025-10-06 Mon wk41 06:50] (current) – [MSExcel Tips] baumkp
Line 1: Line 1:
-{{tag>mswindows windows setup tip notes personal license}}+{{tag>mswindows windows setup tip notes personal license powertoys}}
 ======KPTree - MSWindows Setup====== ======KPTree - MSWindows Setup======
 =====Background===== =====Background=====
Line 19: Line 19:
   *First up to make easier to load up system   *First up to make easier to load up system
      *Nextcloud Windows client - Cloud server client (**!L**)      *Nextcloud Windows client - Cloud server client (**!L**)
-     *Keepass - Password and other secret info repository (**!L**)+     *Keepass - Password and other secret info repository (L) 
 +     *KeepassXC - Password and other secret info repository, better than Keypass (**!L**)
      *I just use the built in Windows Defender for virus protection now      *I just use the built in Windows Defender for virus protection now
      *Xplorer2 - a multi-paned file explorer replacement - //I do not use any more. See notes below.//      *Xplorer2 - a multi-paned file explorer replacement - //I do not use any more. See notes below.//
Line 28: Line 29:
      *CCleaner - a Windows system maintenance program, clean junk files and registry and other - **Do not use anymore, looks like spam now**      *CCleaner - a Windows system maintenance program, clean junk files and registry and other - **Do not use anymore, looks like spam now**
      *FileZilla - and sFTP client program (**!**)      *FileZilla - and sFTP client program (**!**)
-     *Ghostscript - a PDF manipulator (**!L**) +     *Ghostscript - a PDF manipulator (L)  I simply do not use much anymore 
-     *iTunes - Apple iOS update control software - See Separate Section below (**!**)+     *iTunes - Apple iOS update control software - See Separate Section below - I simply do not use much any more.
      *Setup printer / scanner - See separate notes below (**!**)      *Setup printer / scanner - See separate notes below (**!**)
      *Vuescan - Is a paid scanner program. It is just for scanning and is simple and does the job __very__ well. (**!L**)      *Vuescan - Is a paid scanner program. It is just for scanning and is simple and does the job __very__ well. (**!L**)
Line 70: Line 71:
   *YouTube Premium Family.  As much as I do not like supporting Google / Alphabeta I have been enjoying the use of YouTube Premium and they throw in YouTube Music too. The family like too.  Getting rid of the Ads has been wonderful!   *YouTube Premium Family.  As much as I do not like supporting Google / Alphabeta I have been enjoying the use of YouTube Premium and they throw in YouTube Music too. The family like too.  Getting rid of the Ads has been wonderful!
   *Spotify - My son originally wanted this and I ended up going with family option.  Have move to YouTube option as it includes YouTube plus Music.   *Spotify - My son originally wanted this and I ended up going with family option.  Have move to YouTube option as it includes YouTube plus Music.
-====Microsoft PowerToys: Utilities to customize Windows==== +=====Microsoft PowerToys: Utilities to customize Windows===== 
-[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]+  *[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]] 
 +  *[[https://github.com/microsoft/PowerToys|Github PowerToys]] 
 +  *[[https://learn.microsoft.com/en-us/windows/powertoys/fancyzones|Fancy Zones utility]] 
 + 
 +====Some key short cut keys==== 
 + 
 +The Windows key is called the Super or Meta Key on Linux.  I will call the Meta key. 
 +So below is a list of special action keys. 
 +  *Shift (shift key, left or right) 
 +  *Alt (alt key, left of right) 
 +  *Ctrl (Control key, left or right) 
 +  *Meta (Meta, Super or Windows key, left or right) 
 +  *→ (Right arrow key) 
 +  *← (Left arrow key) 
 +  *↑  (Up arrow key) 
 +  *↓  (Down arrow key) 
 +  *PgUp (Page up Key) 
 +  *PgDn (Page Down Key) 
 + 
 +===Always on Top=== 
 +  *Activate/Deactivate:  Meta + Ctrl + T 
 + 
 +===FancyZones==== 
 +  *Activate/deactivate: Meta + Shift + ` 
 +  *Apply saved Custom Layout: Meta + Ctrl + Alt + Number 
 + 
 ====Software Licenses and Copyright==== ====Software Licenses and Copyright====
 I am not overly pious about free versus purchased software.  I appreciate people should be rewarded for their efforts.  One has to have the upmost respect for those providing "free" software (true free, e.g. GNU free, **NOT** Facebook or Google free) .  Sadly in general paid software providers merit less respect.   I am not overly pious about free versus purchased software.  I appreciate people should be rewarded for their efforts.  One has to have the upmost respect for those providing "free" software (true free, e.g. GNU free, **NOT** Facebook or Google free) .  Sadly in general paid software providers merit less respect.  
Line 219: Line 246:
 ======MSExcel Tips====== ======MSExcel Tips======
  
 +=====Show 2 sheets of same file=====
 +Use the menu ''VIEW => New Window'' to open a new window in the active workbook
 =====MS Excel Highlight Row or Column===== =====MS Excel Highlight Row or Column=====
 The basic built in way : The basic built in way :
Line 227: Line 256:
  
 Use a VB macro.  Main down side to this is that it slows down the MSExcel performance Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
-<code basic>Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)+++++VB Code 1| 
 +<code> 
 +'from https://www.exceldemy.com/learn-excel/highlight/row/ 
 +Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
 +  If Target.Cells.Count > 1 Then Exit Sub 
 +  Application.ScreenUpdating = False  
 + 
 +  'Clear the color of all cells 
 +  Cells.Interior.ColorIndex = 0 
 +  With Target 
 +    'Highlight row and column of the selected cell 
 +    .EntireRow.Interior.ColorIndex = 38  'or use RGB(200,200,200) to pick a colour 
 +    .EntireColumn.Interior.ColorIndex = 24 
 +  End With 
 +  
 +  Application.ScreenUpdating = True 
 +End Sub</code> 
 +++++ 
 + 
 +++++VB Code 2| 
 +<code>'from https://www.howtoexcel.org/highlight-current-row-column/ 
 +Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
 Static xRow Static xRow
 Static xColumn Static xColumn
Line 251: Line 301:
 End With End With
 End Sub</code> End Sub</code>
 +++++
  
 =====Text to Column===== =====Text to Column=====
Line 381: Line 431:
   *''grid'' ''off'' to turn off grid   *''grid'' ''off'' to turn off grid
  
 +====STYLEMANAGER====
 +The command ''STYLEMANGER'' opens up the directory where the plot styles are stored.  Different plot styles can be copied to and from this directory.
 ======Accessibility Contract Checker====== ======Accessibility Contract Checker======
-Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly im+Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly important to allow easier reading.
   *WebAIM   *WebAIM
     *[[https://webaim.org/resources/contrastchecker/|Contrast Checker]]     *[[https://webaim.org/resources/contrastchecker/|Contrast Checker]]
Line 390: Line 442:
   *[[https://stylemanual.com.au/contents/writing/logical-structure/styles-and-templates|Sytle and templates]]   *[[https://stylemanual.com.au/contents/writing/logical-structure/styles-and-templates|Sytle and templates]]
  
-<- home_server:web_server_setup|prev page ^ home_server:index|Start page ^ home_server:index|next page ->+<- home_server:media_vm_setup|prev page ^ home_server:index|Start page ^ home_server:dokuwiki_setup|next page ->