Pasting Visible Cells Only in Excel

Click the total break that you want to see in the spreadsheet.

Click Edit>Go To> Special

Click the button beside ‘Visible Cells Only’

Click OK

Back at your spreadsheet, highlight the cells you want to copy.

Then paste in a new spreadsheet.

This is placeholder text for your new blog entry. Replace it with your own.

How to Set Windows 7 to Login Automatically

Here's How:

1. Click on Start and then enter the following command in the search box:

netplwiz

Press the ENTER key.

This command will load the Advanced User Accounts Control Panel applet.

2. In the Users tab, uncheck the box next to Users must enter a user name and password to use this computer.

3. Click on the Apply button at the bottom of the User Accounts window.

4. When the Automatically Log On dialog box appears, enter the user name you wish to automatically login to Windows 7 with. Then enter your account password in the two fields where it's asked.

Click the OK button.

5. Click OK on the User Accounts window to complete the process.

From now on, when your PC starts up, Windows 7 will log on automatically

FCHS Bells

To manage the bells at FCHS, go to 10.1.0.5, the PBX Management Interface and click on BELLS.
Username is fchs and password is fclions and it is case sensitive so all lowercase.

Click on BELLS to add any time that you want a bell to ring and the tone and zone destination. Click SAVE at the bottom of the screen.

Click on SCHEDULES from the home page to set which schedule will ring. There should be one set to Default-ON. To turn it on or off default, click on the schedule name, such as DAILY. Just above the list of bells that will ring on this schedule, there is a box for 'Default-ON Schedule'. If you want to turn this schedule on, click that box. If you want to turn it off, uncheck that box.
With the exception of summer days, the DAILY should be checked. Be sure to SAVE at the bottom of the page.

For Exam days or other exception days, click on EXCEPTION SCHEDULE DAYS. You can add days dates with the schedule you wish to ring on that day but clicking the + at the top right of the page. Select your date and schedule, then SAVE.

iPhone Stuck in Restore

I used Tiny Umbrella to get an iPhone 5 out of the restore cycle (iTunes and USB symbols on phone). It did this during an update. 

Download Tiny Umbrella>> Launch the app>> plug in iPhone. The phone will show in the left menu on Tiny Umbrella. Choose it and then chose to stop the restore. 

This set the phone back to its original state (not factory but before the update attempt).

**THIS WILL KEEP YOU FROM UPDATING YOUR PHONE LATER ON. YOU MIGHT NEED TO REMOVE THE APP OR EDIT A LINE IN THE REGISTRY TO MAKE IT UPDATE.

Merging 2 Excel Documents

This video will show you how to merge 2 Excel spreadsheets when you have a common field to match on.

Excel vlookup function

Smart Fusion Install

For PC:

Go to 10.10.1.7/dpclient and use the install link at the top

If you run the client install so it puts the icon on the desktop, the main thing to check besides the compatibility is that the URL is in the Trusted Sites portion of the Security Tab in Internet options.

               Tools, Internet Options, Security, Trusted Sites, Sites and add the URL.

You might have to reboot after that.

Also, Run as Admin

For Mac

To add an icon for Smart Fusion for Macs, you will need to create a Remote Desktop Connection icon for their desktop.

Remote Desktop Connection can be found in the Applications folder.

Steps:

Open Remote Desktop Connection.

Enter 10.10.1.7 but do not hit Connect yet

Go to RDC at the top and choose Preferences 

Enter the username (for the first login) 

Enter the password (password is password for all logins here)

Enter csidp for the Domain

Then click Applications in the RDC Preferences pane

Enter a check mark in the check box

Copy and paste this in the first box: C:\Program Files (x86)\CSI\SmartFusion\autoupdateclient.exe

Copy and paste this in the second box: C:\Program Files (x86)\CSI\SmartFusion\

On the Security tab, check the Connect Even if Authentication Fails box

Then go to File>>Save As and name it Smart Fusion and save it to the desktop. (If your bookkeeper uses a Mac, she will need two separate icons for the SA account and one for the regular account). 

When they open this, they will get a message about the server name bring incorrect. Just hit Connect. (I have reported this to CSI for a way to fix)

For Remote Desktop 10

Before adding, the user account must be edited in Active Directory.
On the Environment Tab, check the first box
paste this:  C:\Program Files (x86)\CSI\SmartFusion\csiwinforms.exe

then this:  C:\Program Files (x86)\CSI\SmartFusion

Click Apply

Add the Remote Desktop App

Add a Desktop

Add 10.10.1.7 as PC Name

Add User Account (csidp\username, password, name it Smart Fusion)- Click Add

Splitting Cells in Excel

• If you want to divide a single cell, locate and click the cell. If it is a range of cells to be divided, highlight them all (note, the range can be any number of cells, but the range must be contained within the same column). Alternatively, you can select an entire column to be divided by clicking the column letter.
• Ensure the cells to the right of the selected column, cell or range are blank – or they will be overwritten. Select the Data menu, and click Text to Columns.
• The Text to Columns Wizard is displayed. This will detect whether or not the source data is separated by spaces or commas, and then presents several options such as the ability to set field widths and column breaks.
  
  In Step 1, selecting Delimited will force Excel to separate the source data by commas or tabs, whereas Fixed Width will force it to look for spaces instead. CHOOSE DELIMITED FOR SPACES TOO!
  
  E.g. a cell containing “1,1,1,1” should be separated using Delimited, and “1 1 1 1” should be separated with Fixed Width.
  
  Click Next.
• In Step 2 of the Wizard, set the column breaks. A single left-click creates a column break, and double-clicking a break will delete it. You can also drag the column break markers, to increase or decrease width. Click Next.
• In Step 3, select a format for the column based on the type of data being separated (e.g. General, Text, Date). Click Finish.
• The data is extracted from the source column, cell or range of cells and split out over multiple cells.