Quick Bytes IT Stuff

Excel is an spreadsheet tool. However, it can also be useful to as a word or a text editor. Such as creating a simple file with links, URLs or website name and saving the file as PDF. One way to create PDF is by printing the file and selecting a PDF printer and of course the file will be in PDF format. In some cases, after printing to PDF the URLs or website links may not work. Or the text hyperlink is not clickable. Other way to save the file as PDF in Word or Excel is to used the "save as" option and save the file as PDF. To save the Excel file as PDF and to preserve the Hyperlinks or make the link clickable in PDF, follow the steps below. - On the Excel file, click "File" - This will open a few options and "save as" is one of them - After clicking "save as", it will show the option where to save the document - You can click "This PC" and select "Documents" - The file will be saved on Documents folder - Afte...

016-799 Fuji Xerox or Fuji Film print error code. That shows a description error as “Print instruction Fail detected in decomposer.” The error code and error description are alien languages for users and even system administrators who are not familiar with Fuji Xerox error code. The error code is quite simple and easy to fix, if the job print goes to the printer but print out doesn’t come out. So, basically the print job was received by the printer, but the printer just doesn’t know what type of paper or what size to use or which tray to utilize for the print out. In some instances, this is just a paper mismatch but the error description; if using Windows 10 to print does not exactly points to what is the issue. First thing to check, is the paper size selected by the user to print. Example, if the printer configuration is A3 and A4 sizes only. But then the person printing the file accidentally chooses “A4 Cover” then this error 016-799 will occur. ...

There’s quite a lot of ways to do this in Excel, using Macro or Excel formula will be able to get the desired output. Macro I think is good if the number of rows is not so large, but if the number of rows is quite large then a buffer overflow error might occur. Formula can take quite large of data and able to deliver the result as expected. ISNUMBER is a function that can check whether value is a number or not, the function itself tells what the formula will be doing. Adding a search function to ISNUMBER then it can be used to search for a string with in a cell or the specified range in the formula. Example below shows how ISNUMBER can be used to search for a specified string whether it exists or not. The position of the string doesn’t matter as long as the string exist within the cell, the formula will return TRUE, otherwise it will return FALSE if the string does not exist. Here’s the example: =ISNUMBER(SEARCH("search string", A5)) The “...

How to insert a header or footer in Excel 2016? How to insert a custom header or footer in Excel 2016? To insert a custom header or footer with a picture or other sort of customization, can only be done of course using the custom header or footer option. The easiest way to find header and footer is clicking on Insert on the main menu and selecting or clicking header and footer options on the ribbon tab as shown in the image below. If the author of the file has inserted a custom footer or header, sometimes the footer it’s either the header or footer will not be shown. If you need to delete, remove, change or alter the custom footer or custom header, it can be done by the steps below. Steps is shown in the image below. Click on “File”, click “Print”, click “Page setup” a small text found on the bottom right side of the print window. After clicking “Page Setup”, a window will open, then click on “Header/Footer” option. Cheers, till next time! Hope i...

Opening files in Outlook shows an error message that there is not enough free memory to run the program. But the computer has enough RAM installed and no other application is running on the computer except Outlook. Office programs by default don't trust or block files originating from the Internet. This is of course a good security settings but if this setting is getting to your nerves because even if the document that is coming from your own domain you are not able to open. Or the file is originating from your own personal email account other than your company email but when it goes to your Outlook you cannot open it. This is the scenario where good and harsh words will start crossing your mind. You will need to ask what the heck is going on? The Microsoft link below provide some solution on how this thing can be resolved. The article title of the link below is: Error message in Outlook: "There is not enough free memory to run this program. Quit one...

How to print multiple files with opening them? How to print multiple PDF files in one go? Printing is an easy and straight forward task, but if you need to print a 100 or more files but time is a constraint then you have to think twice how to do it fast and easy. Of course, open, click and print is the usual method of printing. To print multiple files without opening them in Windows, just go to devices and printers. Double click the printer and it will open a printer task window which shows what files are being printed. In Windows 7 if you right click the printer name, click on "See What's Printing". If you need to print in double side the printer has to be set before printing because it will just print automatically with the default settings. This method works well for a Fuji Xerox printer, but it should also work with other brand of printer. See screen shot below: Cheers! Hope it helps to make things faster. Till next time... =====...

If you have been playing with the chart in Word or Excel you might encountered that the point on the graph is quite small. If you need to adjust the data point on Word graph, you have two options do it manually or simply automate it at runtime using a VBA code. Assuming you have all the necessary parameters that creates the graph via VBA, and you just need to adjust the data point you can use the code below, the code below was tested using Word 2016. It may not apply to older versions but I think logic should stay the same. cht.SeriesCollection(1).Format.Line.Weight = 9.75 To do it manually, click on the data point and right click on it and select “Format Data Point”, click the bucket icon and change the width value. Here’s the screen shot using Word 2016: For the sake of completeness, the code will be something like this: Dim shp As Shape Dim cht As Chart   Set shp = ActiveDocument.Shapes.AddChart(xlXYScatterLines)      ...

Do you want to check what’s the name of the chart in Word 2016? Or you just want to rename the chart in Word 2016 to a name, that the chart represents? Word 2016 default chart name is in sequence, like Chart1, Chart2, Chart3 and it follows this pattern depending on how may charts you have at your document. If you have multiple charts in a word document, and you want the chart name it to something meaningful or what the chart itself is all about; it’s quite easy and straight forward to rename a chart, but the way to rename it is not conventional as the previous way of doing it in other version of office. You can rename the chart via VBA code or using the GUI in Word itself. To rename or check the name of the chart in Word 2016 or O365. Click on the chart: After clicking the chart, the "Chart Tools" will open at the Ribbon. Click the "Chart Tools"  at the ribbon. Click on the "Format" tab. Under Format tab, click ...

To sort numbers, digits, or figures in Excel 2016 is quite straight forward. There are two ways to do it via the Home tab or Data tab. What is found on the Home tab is sorting of alphabets or A-Z option which can easily be seen beside the auto-sum function which is on the right most tab of the ribbon by default. Screen shot below shows the sorting functionality found in Home tab. The other way to sort by numbers, digits or figures in Excel 2016 is to click on “Data” click on “Sort” then an option will appear to sort by smallest to largest or largest to smallest. A screen shot below shows where to find the function. That’s it hopes it helps to make thing easier. ================================ Free Android Apps: Click on links below to find out more: Excel Keyboard shortcuts guide https://play.google.com/store/apps/details?id=chrisjoms.myexcelapplicationguide Linux Android App cheat sheet: ...

Set excel worksheet visibility by changing its property. Simple and a one liner code to hide and unhide worksheet in Excel. Sub Visible_Sheet() Worksheets(1).Visible = 1  'Make the worksheet visible End Sub Sub Hide_RightClick_Unhide() Worksheets(1).Visible = 0    'Hide Worksheet to Unhide Right click on Sheet name and unhide the worksheet End Sub Sub Super_Hide() Worksheets("calcx").Visible = 2  'Hide Worksheet but right click on Sheet name will not show whether the sheet is hidden or not End Sub Cheers! Till next time. ================================ Free Android Apps: Click on links below to find out more: Excel Keyboard shortcuts guide https://play.google.com/store/apps/details?id=chrisjoms.myexcelapplicationguide Linux Android App cheat sheet: https://play.google.com/store/apps/details?id=com.LinuxMobileKit Multiplication Ta...