#1&#2.

You can create a template file that has the page layouts you like.

Start a new workbook.  Do all the pagesetups you like (and anything else you
like) for each worksheet in that workbook.

Save it as a template file named book.xlt in your XLStart folder.

Each time you click on the new icon, that new workbook will inherit all the
settings from that template file.

If you want new worksheets added to existing workbooks to have these same
settings, set up another workbook template file (one sheet only???) and name it
sheet.xlt.  Save it in the same XLStart folder.

#3.  You can use tools|options|view tab|check/uncheck Formulas
    ctrl-` (control-backquote -- it's the key to the left of 1/! on my USA
                                 keyboard is the shortcut key for this.

#4.  You can use a macro to cycle through each cell in the used area and copy
the value/address/formulas to a new worksheet.  This is pretty unusual.  Are you
sure you really need it.

Option Explicit
Sub testme()

   Dim ActWks As Worksheet
   Dim NewWks As Worksheet
   Dim oRow As Long
   Dim oCol As Long
   Dim myCell As Range
   
   Set ActWks = ActiveSheet
   Set NewWks = Workbooks.Add(1).Worksheets(1)
   
   oRow = 1
   oCol = 1
   With ActWks
       For Each myCell In .UsedRange.Cells
           If IsEmpty(myCell) Then
               'skip it
           Else
               With NewWks.Cells(oRow, "A")
                   .Value = myCell.Address(0, 0)
                   .Offset(0, 1).Value = "'" & myCell.Formula
                   .Offset(0, 2).Value = "'" & myCell.Text
               End With
               If oRow = .Rows.Count Then
                   oRow = 1
                   oCol = oCol + 3
               Else
                   oRow = oRow + 1
               End If
           End If
           
       Next myCell
   End With
           
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm