Showing posts with label Windows. Show all posts
Showing posts with label Windows. Show all posts

Sunday, November 11, 2018

Powerpoint 2016 Flashes Table Before It Appears

This is not a post with a solution, just noting I'm not the only one seeing it: https://answers.microsoft.com/en-us/msoffice/forum/all/table-flashes-in-powerpoint-2016-presentation/214e3675-eacb-4a5d-89e1-2c001f53dbc4

Monday, November 5, 2018

Display or Hide Zero Values in Excel

Annoying issue where when I changed the formatting to Scientific, all the blank cells became 00E00. I didn't want that crowding my spreadsheet.

Solution:
  • File > Options > Advanced 
  • Under Display options for this worksheet, select a worksheet, and then do one of the following:
    • To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
    • To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.
Source

Sunday, March 11, 2018

Searching for Styles in Word

I was editing format for a proposal and apparently the editor is extremely specific about certain styles. In a huge 100+ page document, I needed to check how many times that style appears. It turns out you can do:
  1. ctrl+f, click the down arrow and choose [Advanced Find]
  2. Make sure the "Find what:" box is empty
  3. Click "More >>" 
  4. The [No Formatting] button should already be Greyed out, if it is not, click it 
  5. Click on the Format Button, select the style and click okay, you will see it added that under the "Find what:" dialogue
Source

Monday, February 5, 2018

Fixing Comment Box Proofing in word files in a document originally created in another language

Ran into a problem today. The collaborators for the project we are working on are foreign so the document they sent me is defaulted to their native language. The challenge is you can simply change the proofing language Review > Language > Set Proofing Language ...  however I noticed when I added comments they still retained the original language. The quick fix for this is:

  1. Show the "Styles" by clicking the Expand Box in the Styles section of the [Home] Tag ribbon
  2. Click [Options]
  3. Change "Selected Styles to Show:" to all styles 
  4. In the style window right click on the Comments Text > Modify 
  5. [Format] > Language > Select English! 
Source: Here

Sunday, October 15, 2017

When saving a word document all comments become by "Author"

As stated in the subject, it is hugely annoying when you are trying to review papers from multiple people that have been passing along a draft if this happens. You need to :

In Word 2010, go to File->Options->Trust Center->Trust Center Settings. Then, uncheck "Remove personal information from the file properties on save"
In Word 2013, it falls under File -> Options -> Trust Center -> Trust Center Settings... -> Privacy Options. It is found under the Document-specific settings section.
 
Source:  here

Tuesday, January 10, 2017

Windows 10 Phone, Sync specific google calendar events

I recently used google calendar to work through some complicated scheduling. I needed to see and cross reference schedules, but I didn't want it all syncing to my phone. Turns out you can click this link and select which sync to the phone:

https://calendar.google.com/calendar/syncselect

Sunday, January 8, 2017

Word Figures and Tables Missing from Table of Contents, Figure and Table Numbers Skipped

Ran into a weird issue when working on a paper. For some reason the paper would skip Fig 2. I had recently made some edits and couldn't figure out why it just jumped from Fig 1. to Fig 3.

It turns out that Track Changes (Obviously turned on for my co-authors) completely messes with the labeling.

Source

Post Below:

Well, I was finally able to answer my own question. the answer might be helpful to others. It turns out that change tracking was wreaking havoc with figure and table numbers in the cross reference lists. I finally went through and selectively accepted changes to all the figure and table titles and the missing figures reappeared in the list.

The problem is that when they go away in the list, they also disappear in the document because the reference IDs become stale, I suppose. So now I get to go through and find all the places I inserted one of the references that disappeared and reinsert it. Thank you Microsoft...

Tuesday, September 27, 2016

Windows 10 Phone Can't Send Email (Reply / Forward)

Recently discovered Windows 10 phone breaks my gmail and I can't reply or forward messages in my inbox. Original solution here: link

You need to delete and recreate your gmail account. Honestly Windows 10 phone added some nice features, but what it broke is insanely messed up....I'm moving to an android.

Tuesday, August 23, 2016

Turn off gray brackets in header in Word 2016

So I had to temporarily change my app local to Japan to run a Japanese game. Anyway when I went into word I had these strange gray brackets appearing in the header section. As described here it turns out they are "Crop Marks" or "Text Boundaries" the guy in that forum had the same issue. Anyway the solution is found here

Basically:

File > Options > Advanced > Scroll down to "Show Document Content" > Uncheck the Text Boundaries and Crop Marks

Friday, July 22, 2016

Windows Office 2016 seems to be missing fonts from Office 2010

I have no idea why the hell Microsoft would decide not to include some fonts. This ends up breaking several of my presentations on an upgrade to 2016. Why?

Some Examples of Fonts I was Missing (incomplete)
  • Arial Rounded MT Bold
  • Berlin Sans FB
  • Berlin Sans FB Demi 
  • Brittanic Bold
  • Century Gothic
  • Eras Demi ITC
  • Eras Bold ITC
  • Eras Medium ITC
  • Franklin Gothic Book 
  • Harlow Solid Italic
  • Kristen ITC
  • Rockwell Extra Bold 
 Turns out that some fonts are associated with other language packs. You can just get the supplemental fonts back though: Link

The other option was to go to http://www.myfontfree.com/ and just search for them.

WTH Microsoft.

Thursday, July 14, 2016

Windows 10 Network Adapter Disabling at Lockscreen

Could be one of two issues:

Method 1:
Regarding this issue, I suggest we turn off power save on your network adapter:

Step 1: Turn off power management on network adapter:

       Open Network and Sharing Center.
       Click the Change adapter settings link in the upper left of the navigation pane.
       Right click the network connection you want to enable/disable power management support on and click Properties .
       Click Configure .
       On the Power Management tab, clear the Allow the computer to turn off this device to save power check box.
Step 2: change settings of wireless network adapter in power option as Maximum performance.

If the issue still persists, considering the power plan settings issue, please help to upload the power report here for further research:

please run this command:

powercfg -energy

Source

OR

Method 2:

Power Options > Change when the computer sleeps >  Put the computer to sleep > Never.

Wednesday, July 13, 2016

Windows Hello, HP Simple Pass, Authentec / Digital Persona Driver

So I own a Hp Pavillion Dv7 latptop from back in the day.

Originally, I needed the Digital Persona Drivers coupled with HP Simplepass to sign onto my computer.

The new awesome thing is Windows 10 has a brand new feature called Windows Hello.

Basically once you add a "pin" you can sign in without a load of bullshit.

The original thread I found to help me out was here:
Link

In Short

  1. Download the Windows 10 Lenovo Driver here "Validity Fingerprint Common Driver"
  2. Resetart the Machine
  3. Go to the Device Manager 
  4. Right Click on the Biometrics Device > Properties > Driver > Update Driver...
  5. [Browse my computer for driver software]
  6. [-> Let me pick from a list of device drivers on my computer]
  7. Uncheck the [Show compatible hardware]
  8. Select Synaptics FP Sensors (WBF) (PID=0017)
  9. Settings > Accounts > Sign-in Options
  10. Create a Pin
  11. Register fingers with Windows Hello 
Yay.