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:37] – [Foxit Pro] baumkphome_server:mswindows_notes [2025-03-18 Tue wk12 17:10] (current) – [MS Excel Highlight Row or Column] baumkp
Line 98: Line 98:
  
 ====iTunes - setup==== ====iTunes - setup====
 +++++I hardly ever use iTunes any more|
 iTunes is software I do not particularly like. First of all I do not use the Music feature having long ago rip my CD collection to MP3 and I simply do not like the way iTunes works. So the only real reason to use iTunes is for my iOS devices, backing up iOS devices etc. iTunes, in typical Apple fashion I find is not smart end user friendly as it has been designed for not smart users and attempts to hide the lower level file system. Further to this the configuration, backups and apps end up being very large amounts of files (multiple 1000s) and using huge amounts of disk space, in some cases well over 200GB!. So to help alleviate the excessive file system use on my primary Windows10 SSD I would like to move to my Linux NAS. The following are the steps to achieve this. iTunes is software I do not particularly like. First of all I do not use the Music feature having long ago rip my CD collection to MP3 and I simply do not like the way iTunes works. So the only real reason to use iTunes is for my iOS devices, backing up iOS devices etc. iTunes, in typical Apple fashion I find is not smart end user friendly as it has been designed for not smart users and attempts to hide the lower level file system. Further to this the configuration, backups and apps end up being very large amounts of files (multiple 1000s) and using huge amounts of disk space, in some cases well over 200GB!. So to help alleviate the excessive file system use on my primary Windows10 SSD I would like to move to my Linux NAS. The following are the steps to achieve this.
  
Line 120: Line 120:
   *iTunes playing up   *iTunes playing up
 However one good trick is to simply run the install file "C:\Program Files\Common Files\Apple\Mobile Device Support\Drivers\usbaapl64.inf". The easiest way being to right click the file in exploer and select the install option. However one good trick is to simply run the install file "C:\Program Files\Common Files\Apple\Mobile Device Support\Drivers\usbaapl64.inf". The easiest way being to right click the file in exploer and select the install option.
 +++++
  
 =====Printer Scanner Setup===== =====Printer Scanner Setup=====
Line 217: Line 218:
  
 ======MSExcel Tips====== ======MSExcel Tips======
 +
 +=====MS Excel Highlight Row or Column=====
 +The basic built in way :
 +  * ''shift+space'' to highlight the row
 +  * ''ctrl+space'' to highlight the column
 +
 +Use conditional formating, but this requires hitting ''F9'' or a VB macro to actually highlight.
 +
 +Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
 +++++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 xColumn
 +If xColumn <> "" Then
 +    With Columns(xColumn).Interior
 +        .ColorIndex = xlNone
 +    End With
 +    With Rows(xRow).Interior
 +        .ColorIndex = xlNone
 +    End With
 +End If
 +pRow = Selection.row
 +pColumn = Selection.Column
 +xRow = pRow
 +xColumn = pColumn
 +With Columns(pColumn).Interior
 +    .ColorIndex = 6
 +    .Pattern = xlSolid
 +End With
 +With Rows(pRow).Interior
 +    .ColorIndex = 6
 +    .Pattern = xlSolid
 +End With
 +End Sub</code>
 +++++
  
 =====Text to Column===== =====Text to Column=====