showing

Why is my Excel Sheet showing nos instead alphabets on Horizontal bar ? https://ibb.co/emPKg9 Is there a fix for this ?

Many thanks for taking the time to stop by and look at this. Is there an easier way to do this or can this be fixed? Part of a longer formula is not responding as I expected it to. I suspect it's my expectations that are wrong. In essence, what I need to achieve is to identify a "Zone"...

Dear All, I facing a problem on excel printout. Now I am unable print any documents. If I select print it showing 200+ pages or more according to cells. Each cells showing one page numbers, even not allowing to remove. Your valuable advice needed. i don't know how to attach the image.

Hi, I was wondering if someone can help me please. I have a long list of equipment that requires calibrations on different cycles. Some weekly, monthly, semi-annual, and annual. I request some sort of way to automate the process as far as showing what is due. I would like to attach file...

Hello! I would like to hide the formula on G, H, and K. Please see the image via a link: https://agrissy92.files.wordpress.com/2018/09/excel_design.png G Column: =IF([@[Payment Due]]>=[@[Date Paid]],,F8*0.05) H Column: =[@Amount]+[@[Late Fee]] K: =ABS(H8-J8) I have been trying to hide...

Hi, I am not sue why but whenever I click the hyperlink in my userform, the toolbox is showing. Private Sub Label1_Click() Link = "https://www.google.com" ActiveWorkbook.FollowHyperlink Address:=Link End Sub Any idea why? How to fix it?

I am wanting cell E1 to show the average of Column H depending on what is showing. The worksheet shows margins for items in our store. I want this to show what the average margin is if only one department is showing or one category or a few departments, etc. Basically, whatever is showing in...

When I amke a bar chart with the dates listed vertically in column A and the values listed vertically in column B the bars are showing series 1 point 2 for example when I hover over the bar. I want it to show the date/year and the value when I hover over it. Why is it not showing that like it...

Hey forum! I am currently working on a chart which is showing time if the format hhmmss. I have some values showing no time (00:00:00). Is there any smart way to hide these values from the data labels? Thanks in advance.

Good Afternoon, Hopefully someone can help me with this issue I have an Excel Document similar to below, with the fields all showing their format as "General" as this is how the data is sent to me. <colgroup><col span="2"><col><col></colgroup><tbody> <tbody> Month Quarter Year Units 1...

Office 365/Excel 2016 I've started to see odd behavior in functions I add to Power Query. They work OK but are not showing up in ActiveWorkbook.Connections enumerations. Here is a simple function. (PO_Code as text) => let values = { {"BLKT", "Blanket"}, {"L", "Lease"}, {"PF"...

Hi, I have many rows of data in one sheet showing productsales by month. I would like to be able to run a macro that cycles through eachrow and creates a Forecast Sheet (Excel 2016) with specific settings (such asthe end date and showing the stats table etc). That’s the first part, just...

HI, Protect option hide in my excel workbook 2010 and I also try to VBA tools aslo but there is not showing option and options also hide.

- On the Insert tab, in the Text group, click Header & Footer. - Under Header, click either the left, center, or right header selection box. - On the Design tab of the Header & Footer Tools, in the Header & Footer elements group, click Picture and then find the picture that you want to insert...

The cells of an excel sheet exported from tally not displaying its contents fully on the formula bar which is why i'm unable o apply filter on those cells.E.g- 500.00 Dr is only showing 500.00 in formula bar and i need to filter aside the Dr's and Cr's separately.Please help..

I have a power query connection only table with dates showing like 6/29/2018 and its data type is Date, which is exactly how I want it. However, when I create a pivot table off this the date above shows like this 29-June. I tried to apply the Date format in Excel to revert it but it does not...

I followed the guide in the link below but have encountered a few problems and do not know how to fix them. 1) I have the combo box but the list in the combo box does not shorten when searching, only the helper column shortens which is less than ideal as the first 20 items in the list stay...

Hello, I am trying to add dynamic range and sum_range to sumif. Sumif it's not showing any error, just showing a blank result. Any ideas??

Hi All, I know that there will be multiple threads about IF statement issues but i thinks mines quite specified :( You will see from below the statement checks for data in the cells and if empty moves onto the next...

Hi All, I have a graph showing a set of data (from a pivot) which is only showing 6 items at the moment (which is correct) but the legend is showing all the other possible items that are included in the pivot but has a value of zero. Is there a way that the legend will only show items that are...