Making Game: How come I can’t print this custom excel slide range?

Original Source Link

So, I basically wanted to print a range of slides. I have about 800 slides in one PowerPoint and I wanted to print out every other slide, so I made the following numbers separated by a comma using Microsoft Excel:

1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59,61,63,65,67,69,71,73,75,77,79,81,83,85,87,89,91,93,95,97,99,101,103,105,107,109,111,113,115,117,119,121,123,125,127,129,131,133,135,137,139,141,143,145,147,149,151,153,155,157,159,161,163,165,167,169,171,173,175,177,179,181,183,185,187,189,191,193,195,197,199,201,203,205,207,209,211,213,215,217,219,221,223,225,227,229,231,233,235,237,239,241,243,245,247,249,251,253,255,257,259,261,263,265,267,269,271,273,275,277,279,281,283,285,287,289,291,293,295,297,299,301,303,305,307,309,311,313,315,317,319,321,323,325,327,329,331,333,335,337,339,341,343,345,347,349,351,353,355,357,359,361,363,365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447,449,451,453,455,457,459,461,463,465,467,469,471,473,475,477,479,481,483,485,487,489,491,493,495,497,499,501,503,505,507,509,511,513,515,517,519,521,523,525,527,529,531,533,535,537,539,541,543,545,547,549,551,553,555,557,559,561,563,565,567,569,571,573,575,577,579,581,583,585,587,589,591,593,595,597,599,601,603,605,607,609,611,613,615,617,619,621,623,625,627,629,631,633,635,637,639,641,643,645,647,649,651,653,655,657,659,661,663,665,667,669,671,673,675,677,679,681,683,685,687,689,691,693,695,697,699,701,703,705,707,709,711,713,715,717,719,721,723,725,727,729,731,733,735,737,739,741,743,745,747,749,751,753,755,757,759,761,763,765,767,769,771,773,775,777,779,781

The problem is it will only print out if I used all the numbers up to around 167 (1 to 167), but states if I include the other larger numbers around the point, an error message states, “This isn’t a valid print range.” How can I get input all these numbers to print out the number of slides I want, using the “custom range:” text box?

As far as I can see, you can only use 255 characters in the custom slide range box:

enter image description here

Tagged : / / / /

Linux HowTo: How to fix continuous cleanups in OneNote

Original Source Link

When I open a new note (Win+N or via the launcher) I get the message

We’re sorry. OneNote is cleaning up from the last time it was open. Please wait.

After a while a new note is opened. This happens at every new note.

I found a workaround: to delete the contents of C:users%userprofile%appdatalocaltemp. This fixes the issue once, that is at the next new note I have the error message again (and, again, the new note finally opens).

These operations are perfectly replicable (new note, error, clean Temp, new note starts ok, next new note has the error, clean up … )

Is there a proper fix for this issue? I have the latest patches and the issue is present on the net for quite a long time already (at least since early 2015).

I had the same issue, even when creating a new workbook.

Solution

It turned out that even when I created a new (local) notebook, some default locations were still pointing to a notebook located in the cloud.

Check this in File -> Options -> Save & Backup -> Save
Maybe one of these locations (for me it was Quick Notes Section) point to an unknown or cloud location. I changed this to a local location and the nagging cleaning popup was gone (just like my cloud sync, but I can live without it).

Downlod the Sendto one note app from Microsfot and then update your printer within the product you are trying to send from

This fixd the problem straight away

https://www.microsoft.com/en-au/store/p/sendtoonenote/9mvjm1z9vwjd

Tagged : / / /

Making Game: How to fix continuous cleanups in OneNote

Original Source Link

When I open a new note (Win+N or via the launcher) I get the message

We’re sorry. OneNote is cleaning up from the last time it was open. Please wait.

After a while a new note is opened. This happens at every new note.

I found a workaround: to delete the contents of C:users%userprofile%appdatalocaltemp. This fixes the issue once, that is at the next new note I have the error message again (and, again, the new note finally opens).

These operations are perfectly replicable (new note, error, clean Temp, new note starts ok, next new note has the error, clean up … )

Is there a proper fix for this issue? I have the latest patches and the issue is present on the net for quite a long time already (at least since early 2015).

I had the same issue, even when creating a new workbook.

Solution

It turned out that even when I created a new (local) notebook, some default locations were still pointing to a notebook located in the cloud.

Check this in File -> Options -> Save & Backup -> Save
Maybe one of these locations (for me it was Quick Notes Section) point to an unknown or cloud location. I changed this to a local location and the nagging cleaning popup was gone (just like my cloud sync, but I can live without it).

Downlod the Sendto one note app from Microsfot and then update your printer within the product you are trying to send from

This fixd the problem straight away

https://www.microsoft.com/en-au/store/p/sendtoonenote/9mvjm1z9vwjd

Tagged : / / /

Making Game: Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Original Source Link

Let say I have an excel sheet with structure like

enter image description here

I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):

enter image description here

And click Ctrl+V. It gives me an error:

enter image description here

Excel think that I need to copy just one column or merge it. But I want excel just to create a few rows and moving all content down. How can I do it?

What you are trying to do, confuses Excel. When you paste an array by selecting one cell (and the pasted area goes into a merged cell), Excel does not know how you want the information pasted into the cells. If you highlight the same number of cells as the copied array, Excel will not have a problem and will paste the information.

Tagged : / / /

Making Game: Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Original Source Link

Let say I have an excel sheet with structure like

enter image description here

I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):

enter image description here

And click Ctrl+V. It gives me an error:

enter image description here

Excel think that I need to copy just one column or merge it. But I want excel just to create a few rows and moving all content down. How can I do it?

What you are trying to do, confuses Excel. When you paste an array by selecting one cell (and the pasted area goes into a merged cell), Excel does not know how you want the information pasted into the cells. If you highlight the same number of cells as the copied array, Excel will not have a problem and will paste the information.

Tagged : / / /

Linux HowTo: How to delete my name and initials from the title bar of Microsoft Word

Original Source Link

I’m using Microsoft Word with Office 365. In order to maintain anonymity, how do I delete my name from the blue title bar at the top right of the Word window, as well as the pink circle next to it that has my initials in the middle of it. Is this possible?

The name in the title bar indicates you are signed in to Office.

According to the article provided below, if this is Office 365, then you’ll have to stay signed in to Office to use the product. That is how the licensing works. Others are reporting that you just need to login once to activate and then can log out. You’re mileage may vary.

If you want to sign out:

In any Office app, go to File > Account (or Office Account in Outlook) > Sign out.

Or, from any internet enabled computer:

  1. From any device, go to your Microsoft account, Installs page and sign in using your Microsoft account, if prompted.
  2. Under Devices, locate the device where you want to sign out of Office.
  3. Select Sign out of Office.

More information can be found here:
https://support.office.com/en-us/article/sign-out-of-office-5a20dc11-47e9-4b6f-945d-478cb6d92071

Only you will see that; another user opening the document will see his name in that place.
It is not a part of the document, but a part of your installation.

Unless you are talking about sharing or capturing your screen, you don’t need to worry about that area.

If the question is about removing personal information from a Word file,
this is how:

  • Open the file in Word
  • In the File menu, click Info
  • Click “Check for Issues” and then “Inspect Document”
  • Select the items you want the tool to check for and especially
    “Document Properties and Personal Information”
  • Click the Inspect button
  • In the window that opens, click Remove All next to the items you want to remove
  • Save the document with this information removed.

For Office365 to be activated, it usually requires to be attached to a user who has the right licence, and by entering that user/password once, actually two independent things happen at once – 1) activating the installation with that user (and periodically checking whether the subscription is still active), 2) logging-in that same user to Office and showing the name/initials, as well as allowing to save to remote locations on Onedrive/Sharepoint etc.
The trick is to log in to activate the Office but then log out. The activation still will be bound to that account, but the login displayed on the office apps won’t. The disadvantage is then that it will perhaps not allow saving files to Onedrive/Sharepoint locations with the ability of Auto-save and simultaneous editation of the same document by multiple people/devices. You can however have the Office activated to another account thant he one who is logged in, so you can log in later with some dummy account without the right O365 licence, and still have the software activated with the former account.

There is a workaround…

1) simply change entry in Registry Editor

CMD >> regedit

2) then navigate to

ComputerHKEY_CURRENT_USERSoftwareMicrosoftOffice16.0CommonIdentityIdentities

3) change key “FriendlyName” to whatever you like

Tagged : /

Making Game: How to delete my name and initials from the title bar of Microsoft Word

Original Source Link

I’m using Microsoft Word with Office 365. In order to maintain anonymity, how do I delete my name from the blue title bar at the top right of the Word window, as well as the pink circle next to it that has my initials in the middle of it. Is this possible?

The name in the title bar indicates you are signed in to Office.

According to the article provided below, if this is Office 365, then you’ll have to stay signed in to Office to use the product. That is how the licensing works. Others are reporting that you just need to login once to activate and then can log out. You’re mileage may vary.

If you want to sign out:

In any Office app, go to File > Account (or Office Account in Outlook) > Sign out.

Or, from any internet enabled computer:

  1. From any device, go to your Microsoft account, Installs page and sign in using your Microsoft account, if prompted.
  2. Under Devices, locate the device where you want to sign out of Office.
  3. Select Sign out of Office.

More information can be found here:
https://support.office.com/en-us/article/sign-out-of-office-5a20dc11-47e9-4b6f-945d-478cb6d92071

Only you will see that; another user opening the document will see his name in that place.
It is not a part of the document, but a part of your installation.

Unless you are talking about sharing or capturing your screen, you don’t need to worry about that area.

If the question is about removing personal information from a Word file,
this is how:

  • Open the file in Word
  • In the File menu, click Info
  • Click “Check for Issues” and then “Inspect Document”
  • Select the items you want the tool to check for and especially
    “Document Properties and Personal Information”
  • Click the Inspect button
  • In the window that opens, click Remove All next to the items you want to remove
  • Save the document with this information removed.

For Office365 to be activated, it usually requires to be attached to a user who has the right licence, and by entering that user/password once, actually two independent things happen at once – 1) activating the installation with that user (and periodically checking whether the subscription is still active), 2) logging-in that same user to Office and showing the name/initials, as well as allowing to save to remote locations on Onedrive/Sharepoint etc.
The trick is to log in to activate the Office but then log out. The activation still will be bound to that account, but the login displayed on the office apps won’t. The disadvantage is then that it will perhaps not allow saving files to Onedrive/Sharepoint locations with the ability of Auto-save and simultaneous editation of the same document by multiple people/devices. You can however have the Office activated to another account thant he one who is logged in, so you can log in later with some dummy account without the right O365 licence, and still have the software activated with the former account.

There is a workaround…

1) simply change entry in Registry Editor

CMD >> regedit

2) then navigate to

ComputerHKEY_CURRENT_USERSoftwareMicrosoftOffice16.0CommonIdentityIdentities

3) change key “FriendlyName” to whatever you like

Tagged : /

Linux HowTo: What does ctrl+. (period) do in Microsoft Word?

Original Source Link

I particularly like the keyboard shortcuts used by OneNote (and a load of other applications), but specifically the ability to use ctrl + . (control + period) to create a bulleted list.

So I created a shortcut in Word to do just that… except, it seems to be doing something else. It works to add the bullet points, but it also looks like it’s doing some other long running process, because every time I do it, I get the loading icon. Unfortunately right now, I just did it on a 100+ page document, and it’s been loading for about 5 minutes right now. When it first popped the loading icon, a status message came up on the bottom that said it was re-paginating.

I went to File > Options > Customize Ribbon > Customize Keyboard Shortcuts and I didn’t immediately see anything else that had that shortcut assigned. I also couldn’t find that shortcut in the list published from Microsoft’s list of Word Shortcuts.

Question: What else does the ctrl + . shortcut do? Or could it be caused by the bullet gallery action? It seems to get worse with the size of the document.

What command did you choose to create this shortcut?

I try to create the shortcut Ctrl+. (Ctrl + period) for FormatBulletDefault, it seems work smoothly in my small document.

enter image description here

Besides, there are two existed shortcuts provided by Word to apply or remove bulleted list formatting, you may check whether these shortcut keys have same problem in big document.

  • Ctrl+Shift+L: applies the predefined List Bullet style.

  • Ctrl+Shift+N: removes bullets to apply normal style.

Tagged : / / /

Making Game: MS Office Repair Issue

Original Source Link

I am really desperate trying to fix microsoft office.

I received message that office is broken and won’t start, after that I tried to repair (Quick and Online) but didn’t help.

Tried to uninstall and was unable to uninstall. Used “Microsoft Support and Recovery Assistant” and finally uninstalled it.

I have deleted all folders related to Office and cleaned registry.

Restarted multiple times.

Tried to install but again without luck.

“Microsoft Support and Recovery Assistant” is unable to install office too.

I tried office 2013, 2016 and 2019. Couldn’t install but 2010 installed without issue.

Also checked comp for viruses…

Don’t know what else to try.

Tagged :

Linux HowTo: Cannot find the “presenter view” check box in Office 365

Original Source Link

I am using Office 365 which is provided by my work. The license is: “Office for the web (Education)”. I want to present my powerpoint slide in a “presenter view”. When I click the “Slide Show” I do not find this checkbox. According to a Microsoft answer about a similar question, I should find a checkbox there.

Can you explain how to use “presenter view” in Office 365 web edition? Is there any solution to this problem?

The Slide Show menu only has these options:

See this image

The Presenter View is not supported on PowerPoint for web.

Please refer to “Compare PowerPoint features on different platforms

enter image description here

Tagged : / /